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 , 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 didn't calculate to the condition which i set in Status Column.
how to fix this ?
Thanks
Solved! Go to Solution.
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
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
HI , Maybe i got some error in some of this part.
Can you help me on this ?
Thanks with Regards,
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
woww , look perfect. thanks you 🙂
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
@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
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |