Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Thanks in advance!!
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |