Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
Could you give me a hint?
Below a simple Incom Statement:
This means, for the 1st column, MARGIN 2 should be 20.860 - 8.565 = 12.295, MARGIN 3 20.860 - 8.565 - 4613 etc.
Thanks,
Jiri
Solved! Go to Solution.
Hi @jure_rak
You can achieve this in the table using DAX, but the measure created won't be able to use in the column in the Matrix.
Let me know if you'd like to get below results:
M1=178
M2=178-3
M3=178-3-7
...
Add below measures:
Measure = IF(MAX('Table'[Index])=0,0,CALCULATE(MAX('Table'[Sales]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])-1)))
Measure 2 = 178-CALCULATE(SUMX('Table',[Measure]),FILTER(ALL('Table'),[Margin]<=MAX('Table'[Margin])))
Pbix attached.
Hi @jure_rak
You can achieve this in the table using DAX, but the measure created won't be able to use in the column in the Matrix.
Let me know if you'd like to get below results:
M1=178
M2=178-3
M3=178-3-7
...
Add below measures:
Measure = IF(MAX('Table'[Index])=0,0,CALCULATE(MAX('Table'[Sales]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])-1)))
Measure 2 = 178-CALCULATE(SUMX('Table',[Measure]),FILTER(ALL('Table'),[Margin]<=MAX('Table'[Margin])))
Pbix attached.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |