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.
Dear all
I have the following matrix.
I have the following DAX to calculate FFL_YTD_REV by adding the "Addback Dep" value.
The problem to solve for me here is the "Addback dep" is added in the total also in FFL_YTD_REV which I don't want.
How to achieve that, pls help.
Thanks.
Solved! Go to Solution.
hI @Thulasiram ,
You need to add a condition so Addback Dep is not included in the total which would be something like:
IF (
NOT ( HASONEVALUE ( 'table'[ffl major column] ) ),
[mesure without addback dep],
[measure with addback dep]
)
Proud to be a Super User!
hI @Thulasiram ,
You need to add a condition so Addback Dep is not included in the total which would be something like:
IF (
NOT ( HASONEVALUE ( 'table'[ffl major column] ) ),
[mesure without addback dep],
[measure with addback dep]
)
Proud to be a Super User!
User | Count |
---|---|
81 | |
80 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |