Forum Discussion

qwerttty's avatar
qwerttty
Icon for Helper I rankHelper I
3 years ago
Solved

Measure data in calendar

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

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.           

5 Replies

    • qwerttty's avatar
      qwerttty
      Icon for Helper I rankHelper I
      3 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      qwerttty
      Icon for Helper I rankHelper I
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.