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.

[v-pgoloju]

Hi @Sania-F,

 we kindly request you to share the sample data as suggested by @tayloramy  in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Regards,
Prasanna Kumar

[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.

If the issue still persists, we kindly request you to share the sample data as suggested by @tayloramy  in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Regards,
Prasanna Kumar

Prasanna Kumar

[tayloramy · Accepted solution]

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.