Create Level Based Measures in Which should not change based on Filter

[Prudhviraj]

Hi Guys,

Can any one help me out, how can I create a level based measures in Power BI Desktop.

User will select a detail level column value will come from drill through filter. I have to show detail level count for that selected value and also show the count for other levels.

Quick response would be really appreciable.

Thanks,

Prudviraj

[v-jiascu-msft]

Hi @Prudhviraj,

Could you please mark the proper answer as solution?

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

Hi @Prudhviraj,

The detailed level count could be like this:

detailed_level = count('table'[Dealer])

The all the levels could be like this:

all_level =
CALCULATE ( COUNT ( 'table'[Dealer] ), ALL ( 'table'[Dealer] ) )

Or you can post the expected results.

Best Regards,

Dale