Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have requirements to get the % of defect using the formula defect % = defect count / volume qty.
the problem is i'm getting the overall volume qty even i'm using a month filter from a page and it should be getting the volume for that particular month.
Right now it display 171166, the correct value should be 25973 of volume qty. January. May i know if i'm missing from my measure of volume qty. could not figure out if this is correct.
measure to get the volume qty
Try like
volume qty= CALCULATE(table[defect Count], ALLSELECTED(table))
@amitchandak its possible to use the code you've given with filter. I need to calculate the defect count and filter the column1 = "ASY"
CALCULATE(table[defect Count], ALLSELECTED(table))
Hi, Already found the root cause why its is not working correctly when I do the filtering. This is what I found In filter on visual I have excluded the empty defect and also perform top 10 defect. So removed these filters and the volume is displayed correctly. However, how can I perform a top 10% that will not affect the values and also the empty defect will ot be displayed in the visual?
Thank you.
Thank you.
The code is working fine when i used to the first type of defect. but when i used it to another type of defect the volume qty is wrong where in it should be the same from the first one 25973.
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
31 | |
19 | |
18 |