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...
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Chanleakna123,

     

    Please try to remove "(" highlighted: 

     

     

    Also you can copy and paste your DAX in this site to check if any error needs to be correct: http://www.daxformatter.com/

     

    Best Regards,
    Qiuyun Yu

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, 

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

    Hi Chanleakna123,

     

    Please try to remove "(" highlighted: 

     

     

    Also you can copy and paste your DAX in this site to check if any error needs to be correct: http://www.daxformatter.com/

     

    Best Regards,
    Qiuyun Yu

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

      woww , look perfect. thanks you :) 

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        8 years ago

         

        hi , I found the mistake here , my Plant Day Cover is 15.94 , Status 2 should display High here , 
        May i know what happen here ? 

        Thx