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 detail level count for that selected value and also show the count for other levels.

 

 

Quick response would be really appreciable.

 

Thanks,

Prudviraj

 

 

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

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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