FILTER CONTEXT - ISINSCOPE- used for hierarchy level filter test/checks

[Sania-F]

observe the resulty with each dax

dax - 

Revenue % total country =

var currentRegionRevenue =[Revenue]

var totalCountryRevenue = CALCULATE([Revenue],REMOVEFILTERS('Sales Territory'[Region]))

RETURN totalCountryRevenue  /*think its calculating and returning denominator by removing filter on region */

Added divide function to see %

Revenue % total country =

var currentRegionRevenue =[Revenue]

var totalCountryRevenue = CALCULATE([Revenue],REMOVEFILTERS('Sales Territory'[Region]))

RETURN

DIVIDE(currentRegionRevenue, totalCountryRevenue)

Now see the data with ISINSCOPE filter (our region is in hierarchy level) sop using isinscope

DAX- 

Revenue % total country =

var currentRegionRevenue =[Revenue]

var totalCountryRevenue = CALCULATE([Revenue],REMOVEFILTERS('Sales Territory'[Region]))

RETURN

if (ISINSCOPE('Sales Territory'[Region]),

DIVIDE(currentRegionRevenue, totalCountryRevenue)

)

also formatted the measure to percentage.

[tayloramy]

Hi @Sania-F, 

Can you please provide sample data and what the expected output from the sample data is? 

See these posts: 
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Qu...

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[v-pgoloju]

Hi @Sania-F,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @tayloramy   for prompt and helpful response.

Just following up to see if the Response provided by community member were helpful in addressing the issue.

If one of the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Sania-F,

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @Sania-F,

Just following up to see if the Response provided by community member were helpful in addressing the issue.

If one of the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar