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,
I have a list of a table of defective value / total value by date and factory location.
In E2, I like to show the result of D10 / D5 , could you please help!
All the best,
Paris
Solved! Go to Solution.
Hi, @paris
Based on the above data, I guess there is an error in the description, E2=D2/D5 instead of D10/D5.
So, try to create a measure like this:
Measure =
VAR _def =
CALCULATE (
SUM ( [Value] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Factory] ),
[ltem] = "Defective"
)
)
VAR _Total =
CALCULATE (
SUM ( [Value] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Factory] ),
[ltem] = "Total"
)
)
RETURN
IF ( MAX ( [ltem] ) = "Total", BLANK (), DIVIDE ( _def, _Total )
Result:
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @paris
Based on the above data, I guess there is an error in the description, E2=D2/D5 instead of D10/D5.
So, try to create a measure like this:
Measure =
VAR _def =
CALCULATE (
SUM ( [Value] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Factory] ),
[ltem] = "Defective"
)
)
VAR _Total =
CALCULATE (
SUM ( [Value] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Factory] ),
[ltem] = "Total"
)
)
RETURN
IF ( MAX ( [ltem] ) = "Total", BLANK (), DIVIDE ( _def, _Total )
Result:
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Zeon Zheng,
Thank you so much for your help. It worked nicely , thank you again.
Thank you again,
All the best,
Paris
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |