Forum Discussion
Calculate difference between rows
Hi,
I need to calculate difference between rows based on max value for that column in a specific area.
I can calculate difference between rows based on max value for that column (votes achieved) but not on specific area(constituency name). I have used below forumla for same.
Measure 2 = CALCULATE(MAX(bis_candidates[bis_votesachieved]), ALLSELECTED(bis_candidates)) - MAX(bis_candidates[bis_votesachieved])
How can I calculate difference based on area in whole table.
PFA.
Please help.
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
3 Replies
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
