Level of Detail Expression

[dsittrop]

Hi All,

I ave the following table:

I would like to see the sum of 'Candidate_First Pref_Votes_ByLocation' by 'Party_Id' only. I.e. the value if 'HOR_Candidate_id' was taken out of the table.

I have looked at other posts about DAX expressions, however still have not been successful.

Update: I think I may have solved it:

Total Votes of party = CALCULATE(SUM('Dashboard 1'[Candidate_First Pref_Votes_ByLocation]),ALLEXCEPT('Dashboard 1','Dashboard 1'[Party_Id]))

Does that look correct?

[Ashish_Mathur · Accepted solution]

Hi,

Remove HOR_Candidate_ID from the visual and drag this measure

=SUM('Dashboard 1'[Candidate_First Pref_Votes_ByLocation])

[amitchandak]

@dsittrop , Which LOD, in case your are referring to Tableau

all expect means only that filter will work

Try

CALCULATE(SUMX(values('Dashboard 1'[Party_Id]),'Dashboard 1'[Candidate_First Pref_Votes_ByLocation]))

or

CALCULATE(SUMX(values('Dashboard 1'[Party_Id]),calc(sum('Dashboard 1'[Candidate_First Pref_Votes_ByLocation]))))

refer

Tableau Fixed Level of Details in Power BI- Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details): https://youtu.be/QdnOHcZqkPU

LOD Include (Level Of Details): https://youtu.be/nmBVc2fN6aU

LOD exclude (Level of Details): https://youtu.be/wJEjG3O3vrk