Count of Occurrences of a measure

[MadhuriReddy]

In PowerBI, I am trying to figure out how to perform a count of stores based upon the percentage groups

PCNT_Measure = DIVIDE(SUM('Table'[Visit]), SUM('Table'[Schedule]))

For example, if all 4 months are selected

The desired result would be:
100% = 3 stores
75% = 1 store
50% = 2 stores

This count/percentage would then change if different months were selected.

For example, if only months 1 through 3 were selected...
...then the count would be:

100% = 3 stores
66.7% = 3 stores

[v-jingzhang · Accepted solution]

Hi @MadhuriReddy 

You can use the following measure. This measure works when adding it to a visual which has [Store] column. If the visual doesn't have the [Store] column, the variable _pcnt cannot get the correct result then COUNTROWS would probably return a blank result.  

Count_PCNT = 
var _t = SUMMARIZE(ALLSELECTED('Table'),'Table'[Store],"PCNT",[PCNT_Measure])
var _pcnt = [PCNT_Measure]
return
COUNTROWS(FILTER(_t,[PCNT]=_pcnt))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[MadhuriReddy]

Thank you @v-jingzhang 

[MadhuriReddy]

Sample Data

Store	Month	Schedule	Visit
Store #01	2022_01	1	1
Store #01	2022_02	1	1
Store #01	2022_03	1	1
Store #01	2022_04	1	1
Store #02	2022_01	1	1
Store #02	2022_02	1
Store #02	2022_03	1	1
Store #02	2022_04	1	1
Store #03	2022_01	1	1
Store #03	2022_02	1	1
Store #03	2022_03	1
Store #03	2022_04	1
Store #04	2022_01	1	1
Store #04	2022_02	1	1
Store #04	2022_03	1	1
Store #04	2022_04	1	1
Store #05	2022_01	1	1
Store #05	2022_02	1	1
Store #05	2022_03	1	1
Store #05	2022_04	1	1
Store #06	2022_01	1
Store #06	2022_02	1	1
Store #06	2022_03	1	1
Store #06	2022_04	1