Total Calculation of Table Chart is not based on Measure Condition

[Chanleakna123]

Hi All , 

Anybody can tell me how to fix Measure "Status 2 "  Calculation based on Total Days Cover ? 
Kindly note that Total Days Cover was calculated by Days Cover . I do Measure for First Status Margin based on Days Cover , Look like all the rows correct. and then i had created another measure called Plant Days Cover which the total row looks also and i create another Measure Status 2 Based on the Plant Days Cover . but the condition is not correct. the result sould be Hight not POS. 

[v-qiuyu-msft]

Hi @Chanleakna123,

Would you please share pbix file with some dummy data with us? 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

hi , @v-qiuyu-msft

how can i share you the file ? 

can you tell me ? 

[v-qiuyu-msft]

Hi @Chanleakna123,

You can upload pbix file to your OneDrive and send link to me via private message if the pbix file contains sensitive data. 

Best Regards,
Qiuyun Yu

[Chanleakna123]

@v-qiuyu-msft : please find the link below : 

https://drive.google.com/file/d/1yChv2YnRrXjexFVyL9_XytNz6w5w2NlY/view?usp=sharing

thx

[v-qiuyu-msft]

Hi @Chanleakna123,

I looked into the pbix file, the measure

Status 2 = IF([sales Projection]=0,"No Forecast",IF([Plant day Cover]>[High],"High",IF([Plant day Cover]<=[Avai Max] && [Plant day Cover]>[Avail Min],"Avail",IF([Plant day Cover]<=[POS Max]&&[Plant day Cover]>[POS Min],"POS",IF([Plant day Cover]<[OOS],"OOS")))))

On the total row, the Plant day Cover 26.58 less than High 214, so the value sholdn't be "High". 

What do you mean about "how to fix Measure "Status 2 "  Calculation based on Total Days Cover "? Could you clarify the desired results based on condition? 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

HI @v-qiuyu-msft

Total Days Cover calculated from Days Cover . Plant Days Cover calculated from Total Days Cover. then i create another measure called "Status 2 " which need to based on Total Days Cover of 26.58 of the total rows , and what i set in the column condition is if such each material in attached >7 should be "HIGH" not POS . Therefore , when i display on the dashboard with Card Visualization, it should be HIGH for the materials selction i set. 

Thanks