Count with an arguemnt. Compare Individual count average to Total count average.

[Knarf_G]

Good evening, New to Power BI and loving it already!

I am trying to create a Cluster Bar Chart comparing the amount of times CODE (a CPT code) a Order# (DR) does in a given period (this is working) and compare that to the aveage percentage of the entire group. So i Have two slicers, DOS(date) and Order#(Drs).

I have been trying to do a Total Count AVG = divide(COUNT(AUDIT1[Code]), calculate(count **this is where i am stuck**

I can count the filtered but unable to add a ALLEXCEPT arguemnt in the count. (ALLEXCEPT(AUDIT1,AUDIT1[Trans Type],AUDIT1[DOS],AUDIT1[Code] which it should coninue to filter based on SILCER and Page filters for specific codes, code types, DOS range)

Here is what it currently looks like

Desktop

Thanks in advance!!

[v-qiuyu-msft]

Hi @Knarf_G,

Please try to use ALLSELECTED() function instead of ALLEXCEPT().

Total Count AVG = divide(COUNT(AUDIT1[Code]), calculate(count(AUDIT1[Code]), allselected(AUDIT1).

If above doesn't work, please share the sample data and expected results for us to test.

Best Regards,
Qiuyun Yu