Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost 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

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost 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
Icon for Community Support rankCommunity 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
    Icon for Post Prodigy rankPost Prodigy
    8 years ago

    woww , look perfect. thanks you :) 

    • Chanleakna123's avatar
      Chanleakna123
      Icon for Post Prodigy rankPost 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