Forum Discussion
Calculate difference between rows
Hi Anu
Try this MEASURE
Measure = VAR Max4Constituency = CALCULATE ( MAX ( bis_candidates[bis_votesachieved] ), ALLEXCEPT ( bis_candidates, bis_candidates[ConstituencyName] ) ) RETURN Max4Constituency - SELECTEDVALUE ( bis_candidates[bis_votesachieved] )Yes I believe this feature doesn't exist currently. But hopefully soon it will be available. Each month new updates are released
You can support this idea by VOTING for it
BOOKs provide an organized source of LEARNING. I have all these books :smileywink:
- Building Data Models With Power Pivot
Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI
- Definitive Guide to DAX
Hi Anu
Try this MEASURE
Measure =
VAR Max4Constituency =
CALCULATE (
MAX ( bis_candidates[bis_votesachieved] ),
ALLEXCEPT ( bis_candidates, bis_candidates[ConstituencyName] )
)
RETURN
Max4Constituency - SELECTEDVALUE ( bis_candidates[bis_votesachieved] )Thanks Zubair_Muhammad It worked.! :smileyhappy:
I need to further do ascending sorting on consituency no. and descending sorting on votes achieved. I researched and found that multiple sorting on columns can't be applied in power BI table. Is it so?
I am new to Power BI. Can you suggest from where should I learn making formula like these?
Have a great day!
Yes I believe this feature doesn't exist currently. But hopefully soon it will be available. Each month new updates are released
You can support this idea by VOTING for it
BOOKs provide an organized source of LEARNING. I have all these books :smileywink:
- Building Data Models With Power Pivot
Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI
- Definitive Guide to DAX
