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