Measure to calculate share of rows selected by slicer

[KapGun]

I need to calculate share of rows which have a value selected in slicer.

For testing I created two measures, first counting all rows:

  LT_All = COUNT(Events[Reason])

Then counting only selected rows

  LT_Selected =

  Var  Reason_selected =

  CALCULATE ( COUNT ( 'Events'[Reason]), ALLSELECTED ( 'Events' ) )

  Return

  Reason_selected

And finally wrote the actual measure

  Share =

  Var Reason_selected = CALCULATE ( COUNT ( 'Events'[Reason]), ALLSELECTED ( 'Events' ) )

  Var Reason_All = COUNT(Events[Reason])

  Return

  Reason_selected/Reason_All

However, it shows "100%" :

What am I doing wrong?

[v-jingzhan-msft · Accepted solution]

Hi @KapGun 

You can use this for all, using ALL to remove all filters on the table. 

LT_All = CALCULATE(COUNT(Events[Reason]), ALL('Events' ))

Share:

 Share =
 Var Reason_selected = CALCULATE ( COUNT ( 'Events'[Reason]), ALLSELECTED ( 'Events' ) )
 Var Reason_All = CALCULATE ( COUNT(Events[Reason]), ALL ( 'Events' ) )
 Return
 Reason_selected/Reason_All

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[KapGun]

Great, works like a charm!

Thanks mate 🙂