cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Get the sum of values for rows based on values from two columns

Hi Community, 

 

I am wanting to get these values using DAX; please see definitions below:

 

Total Points in Area = sum of Rating Numeric, filter on respondent, filter on area sort

Points Possible = sum of Area sort, filter on characteristicSupport.JPG 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mariusz New Contributor
New Contributor

Re: Get the sum of values for rows based on values from two columns

Hi @ThePowerBIQueen 

If you are looking to obtain the same results as in the snapshot, if not please reiterate the question.

 

Total Points in Area = 
CALCULATE(
    SUM(YourTable[Rating Numeric]),
    ALLEXCEPT(YourTable, YourTable[Respondent], YourTable[Area Sort])
)
Points Possible = 
CALCULATE(
    SUM(YourTable[Area Sort]),
    ALLEXCEPT(YourTable, YourTable[Characteristic])
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
Mariusz New Contributor
New Contributor

Re: Get the sum of values for rows based on values from two columns

Hi @ThePowerBIQueen 

If you are looking to obtain the same results as in the snapshot, if not please reiterate the question.

 

Total Points in Area = 
CALCULATE(
    SUM(YourTable[Rating Numeric]),
    ALLEXCEPT(YourTable, YourTable[Respondent], YourTable[Area Sort])
)
Points Possible = 
CALCULATE(
    SUM(YourTable[Area Sort]),
    ALLEXCEPT(YourTable, YourTable[Characteristic])
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.