Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago
Solved

Condition Format in Table chart didn't calculated

hi , I have above condition formula. 
look at the table chart , there's Total Days Cover 0.42 . the Status Condition should be in "OOS" not High , But seems like the Total value of Table Chart didn't calculate to the condition which i set in Status Column. 

how to fix this ? 

Thanks 

Dashboards

7 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    From your screenshot, it seems the Total Day Cover is a measure, right?

     

    In your scenario, as the Status is a calculated column instead of a measure, you set First aggregation for the Status column when you put in the table visual. The total row for First Status will not based on the Total Daya Cover, it will find the first value of the Status column then display it("High").

     

    If you want the total row display corresponding status based on Total Day Cover, you need to create a new meausre with the same logic as status column based on Total Day Cover.

     

    Best Regards,
    Qiuyun yu

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

       

      HI , Maybe i got some error in some of this part. 
      Can you help me on this ? 
      Thanks with Regards,