Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a division of two values which are summarized as a Measure. I use this measure in a barchart where I can see monthly percentage value of it.
What I now want to display is a 180 days moving average (6 Month) line within this barchart :
it worked out pretty well for another report. But now I get the error: "Canot find Measure in Percent among KeyMeasure or possible cannot be used"
I guess the problem is that its a scalar value, so I did a calculated calumn as well, of calculated column= valueA/valueB.
Instead of the measure I put the column in. No error. But now I get no values at all. How to work with percentage ? Is there a easier way to write a 180 days moving average with the percentage value?
Thank you very much in advance.
Best.
Solved! Go to Solution.
@Applicable88 , Try a measure like
CALCULATE(COUNTX(values(Mastercalendar[Date]),[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH))
@Applicable88 , Try a measure like
CALCULATE(COUNTX(values(Mastercalendar[Date]),[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH))
Hello @amitchandak,
thanks so much, but I can't display it. the barchart is always showing me no values, no graph for the moving average and I don't know why.
When I use a table to visualize this first I have a value MA Value in every month. Switching back to the chart there is only a bar chart with the absolute monthly value but no graph. I tried also other bar chat visuals with no success. What might be the problem here?
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |