Forum Discussion
rpinxt
Solution Sage
Solution SageCan you make a gauge variable?
So I build this gauge: Now it (of course) reacts when I set the slicer to another quarter. My idea was now to have 1 big gauge for the quarter and make 3 little ones below it for the separ...
rpinxtSolution Sage
Solution SageOk still not working but maybe I found the issue.
I think my measures are not working correctly.
I now for better visibility put it for now in a tabel and Quarter 2 is selected :
As you see last month should be 6. So also for April and May it shoud show 6.
Of course as a result LastMth - 2 will also be incorrect because that should be 4 everywhere.
And then het GaugeFilter-2 would only show a 1 for the line of April (4) and the two later months should be 0.
Could somebody help me adjust my measures?
LastMth =
FORMAT(CALCULATE(MAX(Dim_Date[Date]),FILTER('AAA Rework Merge',ABS(SUM('AAA Rework Merge'[Quantity]))>0)),
"M")
LastMth-2 =
FORMAT(CALCULATE(MAX(Dim_Date[Date]),FILTER('AAA Rework Merge',ABS(SUM('AAA Rework Merge'[Quantity]))>0)),
FORMAT(CALCULATE(MAX(Dim_Date[Date]),FILTER('AAA Rework Merge',ABS(SUM('AAA Rework Merge'[Quantity]))>0)),
"M") -2
GaugeFilter-2 =
IF([LastMth] -2 = [LastMth-2], 1, 0)
IF([LastMth] -2 = [LastMth-2], 1, 0)
*Editt : Important to tell here is that when you take out the field period all looks fine.