Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I'm trying to work out an issue.
I've got severel filters on my report (see photo)
So filter 1: choose from 1 to 5
Filter 2: choose from 1 to 5
And so on,
Is it possible to get the average number from these filters? So for the photo the average should be 3.5
Thanks in advance
Hi @miltenburger,
Try something like this:
Average = DIVIDE ( ( CALCULATE ( SUM ( a[a] ), ALLSELECTED ( a[a] ) ) + CALCULATE ( SUM ( b[b] ), ALLSELECTED ( b[b] ) ) ), ( CALCULATE ( COUNT ( a[a] ), ALLSELECTED ( a[a] ) ) + CALCULATE ( COUNT ( b[b] ), ALLSELECTED ( b[b] ) ) ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
Thanks for your fast reply.
I used following code (because all my filters are based on factCompetentieniveau[cijfer], i did following:
NewAverage = DIVIDE(CALCULATE(sum(factCompetentieniveau[Cijfer]);ALLSELECTED(factCompetentieniveau[Cijfer]));CALCULATE(COUNT(factCompetentieniveau[Cijfer]);ALLSELECTED(factCompetentieniveau[Cijfer])))
When i put my measure on a text box it gives me the value: blank
Got any ideas?
Anybody else got any ideas how to do this?
Maybe it's not even possible, i'm not sure..?
Anyone?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |