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.
Dear forum members,,
I have a rather easy appearing topic, but just can't get to the right DAX formula.
I'd like to show whether a part number (Sys_Plant_CAM) has a value equal zero in a certain column [lo_indreq] or not. The only obstacle is that the part number has various rows for single dates - some zero and some not zero.
I thought it would not be difficult using a Measure like the following to fill the total sum for all those part numbers:
Thanks for any help how to solve the issue.
Solved! Go to Solution.
I think you want this instead:
CALCULATE (
SUM ( 'v_md04_latest'[lo_indreq] ),
ALLEXCEPT ( 'v_md04_latest', 'v_md04_latest'[Sys_Plant_CAM] )
)
You want to remove all filters except the Sys_Plant_CAM.
I think you want this instead:
CALCULATE (
SUM ( 'v_md04_latest'[lo_indreq] ),
ALLEXCEPT ( 'v_md04_latest', 'v_md04_latest'[Sys_Plant_CAM] )
)
You want to remove all filters except the Sys_Plant_CAM.
Thanks Alexis,
it worked perfectly as expected.
Try:
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.