Dynamic KPI Value based on number of people filtered

[Mehal1996]

This post has now been removed.

[veenashenolikar · Accepted solution]

Hi @Mehal1996 ,

You can create a measure that counts how many values are selected as :

Count_SelectedValues = CALCULATE (COUNTROWS ( FILTERS ( 'Table'[Name] ) ),ALLSELECTED ( 'Table' ))

Then, update your target measure as follows:

Target = if([Count_SelectedValues] =1 , 1,[Count_SelectedValues])

Use this target measure on your report.

Please mark this as a solution if it helps you!

Regards,

Veena Shenolikar