Forum Discussion
Hierarchy Subtract
Hello.
I'm having a table with a field Version, up to now it only holds 2 values, 1 or 2 (this is used to compare measures).
But I would now like to define a 3rd value that subtracts the 2 values from the 1 values.
But not on each KPI (we have over 180 measures in our cube).
In Cognos TM1 we could cretae a consolidation of 1 and 2 and gibe weights of 1 and -1.
Anything posible in DAX ?
2 Replies
NipponSahoreResolver II
A little more details would be great
Ok, let say this is the table, this table is used in a filtering system where users can compare 2 versions of a complete set of facts. There is a many-tomanu relationship (intermed table) on SelKey to the facts.
I would like to be able to create a calculated 'version' (ex) 3 that has the formula CompVersion-Value-1 minus CompVersion-Value-2, but that should work on all KPI's. Creating a Hierarchy on Compversion with a element above would sum both, I would like to subtract one ...
CompVersion SelKey Dim1 Dim2 Dim3 Dim4 Dim5 1 1 Plan1 XX OK 01/02/2018 1 2 Plan1 XX OK 02/02/2018 1 3 Plan1 X123 01/02/2018 1 4 Plan1 XY NOK 01/02/2018 1 5 Plan1 XY NOK 02/02/2018 1 6 Plan2 ZZ 01/03/2018 1 7 Plan2 ZZ 02/03/2018 1 8 Plan3 ZZ 01/01/2017 1 9 Plan4 01/01/2018 2 1 Plan1 XX OK 01/02/2018 2 2 Plan1 XX OK 02/02/2018 2 3 Plan1 X123 01/02/2018 2 4 Plan1 XY NOK 01/02/2018 2 5 Plan1 XY NOK 02/02/2018 2 6 Plan2 ZZ 01/03/2018 2 7 Plan2 ZZ 02/03/2018 2 8 Plan3 ZZ 01/01/2017 2 9 Plan4 01/01/2018