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, I have a problem to calculate the count of values from Measure results.
The measure return the Status for each day.
LogStatus =
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)
I need to calculate a count of each status by day. Is possible to do it?
Hey,
did you already to add another measure like so:
CountStatus = VAR CurrentDate = SELECTEDVALUE(AllDates[Date]) RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = currentDate)
And just add the column
'LOG'[VLR_NOVO]
either to the row or columns of your matrix visual.
Regards
Tom
Tom thanks for your return.
I tried to do it, but it does not work, see the prints:
Hi, I need a help to solve a problem to create a DAX Count based in the result of another measure.
Table 1:
I did a measure to return the Status by day::
LogStatus =
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)
Table 2:
I need to calculate the number of occurrences of each LogStatus per day.
How can I do it?
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 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |