Calculate difference between rows

[Anu]

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.

[Zubair_Muhammad · Accepted solution]

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] )

[Zubair_Muhammad · Accepted solution]

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] )

[Anu]

Thanks @Zubair_Muhammad It worked.!

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!

[Zubair_Muhammad · Accepted solution]

@Anu

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-s...

BOOKs provide an organized source of LEARNING. I have all these books

• Building Data Models With Power Pivot

• Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Exce...

• Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI

• Definitive Guide to DAX