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

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 

      • Chanleakna123's avatar
        Chanleakna123
        Icon for Post Prodigy rankPost Prodigy
        8 years ago

        v-qiuyu-msft Plant Day Cover are calculated from Days Cover and Status 2 are calculated in Measure. i want my Status 2 conditon are based on the total number we calculate. 
        can you help me on this case ? 

        Thanks