Forum Discussion
DAX - Adding Measures by using another measure as input
- 6 years ago
Hi 2366 ,
We can try to use the following measure to meet your requirement:
TotalMeasure = SUMX ( DISTINCT ( 'Table'[Year] ), CALCULATE ( [First Measure] ) )It if does not meet your requirement, could you please share your 1st measure if it does not contain any confidential information?
Best regards,
Thanks but the new measure is now returning blanks.
Aplogies I havent given the full background of what I am trying to achieve -
I have a data set like this
Year Month 1 2 3 4
1 100 300 600 1500
2 200 400 800
3 300 500
4 400
I am calculating my 1st measure as sum(next months value)/sum(current months value) by raking the month column.
so my result currently looks like this now -
Year M 1 M2 M3
1 3 2 .4
2 2 2
3 .6
In the next step I want to display a single row as
M1 M2 M3
5.6 4 .4
Hope this helps?
Hi 2366 ,
We can try to use the following measure to meet your requirement:
TotalMeasure =
SUMX (
DISTINCT ( 'Table'[Year] ),
CALCULATE (
[First Measure]
)
)
It if does not meet your requirement, could you please share your 1st measure if it does not contain any confidential information?
Best regards,