Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community!
I am i need of some serious help as I have starred myself blind on this matter.
I have a valuecolumn with decimal values, one value for each new date in the date colomn. I am working with averages of these values. Fx I want to know if the avarage value over a certain period is more than +1 from my target value. Target 5+1=6 and if the average of the values equals 6,2 I want to know. Thus i have a measure like this:
OVProfile = IF([Myavg]>=[AvgProfileGraderTest];IF([Myavg]<=[AvgProfileGrader+1Test];1;0);0)
where Myavg is the average of the value, AvgProfileGraderTest is the target, AvgProfileGrader+1Test is the target +1.
This works and I can create a table showing the cases where this has happended.
However I cannot comprehend how to count the how many cases where this is true. The table cannot Total this measure and I cannot count the measure via Calculate. If I try to count some of the other attributes with this measure as a Filter i get the wrong number. That is because my counting always counts per row (date) and not on the basis of the average from my report filter.
The datastructure is like this:
Help is much appreciated, thanks.
Hi @ragoe,
Here is an artice which provides a workaround that allows us to sum the values returned by measure:
Best regards,
Yuliana Gu
Hi and thank you for the link.
But this case is another one as I see it. My measure looks at the average of a value (over many rows) and provides a 1 or 0 (true false). I cannot sum the measure and I cannot sum a calculated colomn derived from this measure as it returs a 1 for each row and not in the context like the table I showed.
I want to have a total that counts (sums the 1's) the rows showed in the table. The rows in the table are correct, but to count how many rows that are showed in this table context is beyond me.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |