Forum Discussion

Prudhviraj's avatar
Prudhviraj
Frequent Visitor
8 years ago
Solved

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

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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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