PowerBI Measure not grouping by count

[Wargent92]

I have an issue where I can't get my measure to show a summary count correctly.

Here are my data visuals:

The table on the left correctly groups each code into Above average or Below average based on number of items.

Now I want to show a summary count of all codes based on this measure. but it just gives me total and above average which is not correct.

Formulas used:

UK Avg = CALCULATE([Avg Items],ALLSELECTED(GBQ_epraccur202305[Organisation_Code],GBQ_epraccur202305[Name],GBQ_epraccur202305[Postcode]))

Total Items vs UK Average = [Total Items]-[UK Avg]

Status = if([Total Items vs UK Average]>0,"Above Average","Below Average")

Can anyone advise what I'm missing here?

[v-xinruzhu-msft · Accepted solution]

Hi @Wargent92 

You can refer to the following solution

1.Create a table

e.g 

Type={"Above Average","Below Average"}

2.Then create a new measure

Counts =
CALCULATE (
    DISTINCTCOUNT ( GBQ_epraccur202305[Organisation_Code] ),
    FILTER ( GBQ_epraccur202305, [Status] IN VALUES ( Type[Value] ) )
)

Then put the column of type table and the counts measure to the table visual, you can see the related value.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...