Forum Discussion

Icon for Resolver I rank

Resolver I

11 months ago

Solved

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

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
11 months ago
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-Quickly/td-p/1626726/jump-to/first-unread-message
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.

3 Replies

tayloramy
Super User
11 months ago
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-Quickly/td-p/1626726/jump-to/first-unread-message
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.
Anonymous
Not applicable
11 months ago
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
Anonymous
Not applicable
11 months ago
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

Related content