Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |