Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Chanleakna123,
Would you please share pbix file with some dummy data with us?
Best Regards,
Qiuyun Yu
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
@v-qiuyu-msft : please find the link below :
https://drive.google.com/file/d/1yChv2YnRrXjexFVyL9_XytNz6w5w2NlY/view?usp=sharing
thx
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |