Measure data in calendar

[qwerttty]

Hi community, 

I was wondering how to show the count of the text in the table for either 0 or 1. This seems a really easy task but it does not work.

Let me explain in example

In the calendar for 10/9, it should shown 1 for the value which means at that day, there have false in the category. 

All true then 0, if one true and other false should result as 1. 

But the calendar shown the count of the final result. 

Do you have a solution to this issue ?

Many thanks

[Anonymous]

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.           

[qwerttty]

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. 

[Anonymous · Accepted solution]

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.           

[amitchandak]

@qwerttty , check if this can help

Power BI Matrix as Calendar Display & Conditional formatting: https://youtu.be/O93dTEt24ZE

[qwerttty]

Hi @amitchandak ,

I was trying the method that you recommend. 

I'm using the data stated below. 

With the matrix calendar, the final result (T/F) should shown in true, and the final result should shown in 0. 

However, from the matrix for calendar, it does not shown what i want. 

Do you have a solution to this issue ?

Many thanks