Forum Discussion
Measure data in calendar
Hi qwerttty ,
You're trying to group by directory, right?
As I said earlier, if you place the matrix, you are counting this column, so the result is not what you expect. You need to use the [Final Result] field and choose how the minimum value is aggregated.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi qwerttty ,
If you want to group by date, return True or False, you can try creating a calculated column as follows.
Final Result(T/F) =
VAR _SUM=CALCULATE(SUM('Table'[Final Result]),FILTER('Table',[Date]=EARLIER('Table'[Date])))
RETURN IF(_SUM=0,TRUE(),FALSE())
And based on my test, for these custom calendar visuals, for measures that return True or False, by default there are only two aggregation methods: "Count (Distinct)" and "Count".
As a workaround, you can put a number type column of 1 or 0 in the calendar visual, and then select the maximum value for the aggregation type. This will achieve the effect of displaying 1 or 0.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Would there any method to filter by the category also?
And when the Ch4 is True, in the selection of date filter 10 Sep, the matrix shown true, and for other Ch shown false?
Kind regards.
Hi qwerttty ,
You're trying to group by directory, right?
As I said earlier, if you place the matrix, you are counting this column, so the result is not what you expect. You need to use the [Final Result] field and choose how the minimum value is aggregated.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.