TOTAL without Filter

[clem312]

Hi,

I have a measure the sum weights for unique ID. It works fine in my matrix by categories.

My problem is that I need the TOTAL of the weight for all categories in order to make a percentage for each category.

_Q72_Like = SUMX(Values(Q72[ID]), calculate(max(Q72[WEIGHT])))

_Q72_Total = SUMX(VALUES(Q72[ID]), CALCULATE(MAX(Q72[WEIGHT]), ALL(Q72[Q72_correspondance.Q72_lib])))

The last column _Q72_Total should display 101 698 on all cells.
What am I doing wrong ?

[parry2k · Accepted solution]

@clem312 try this measure:

_Q72_Total = 
CALCULATE
(
    SUMX (
        VALUES ( Q72[ID] ), 
        [_Q72_Like] 
    ),
    ALL ( Q72[Q72_correspondance.Q72_lib] )
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[PaulDBrown · Accepted solution]

How about:

_Q72_Total = CALCULATE ([_Q72_Kike], ALL(Q72[Q72_correspondance.Q72_lib]))

[clem312]

@PaulDBrown 

Works fine too Paul 👍

Thank you.

[parry2k · Accepted solution]

@clem312 try this measure:

_Q72_Total = 
CALCULATE
(
    SUMX (
        VALUES ( Q72[ID] ), 
        [_Q72_Like] 
    ),
    ALL ( Q72[Q72_correspondance.Q72_lib] )
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[clem312]

@parry2k 

Perfect. Thank you. 👍

[parry2k]

@clem312 interesting, share pbix file with sample data on how your tables are structured to provide the solution.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[clem312]

Below you can find them

PBIX File 

Data Extract 

[parry2k]

@clem312 try this:

_Q72_Total = SUMX(ALL(Q72[ID]), [_Q72_Like] )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[clem312]

Hi @parry2k 

No. It does not change :

 I also tried 

_Q72_Total = SUMX(ALL(Q72[Q72_correspondance.Q72_lib]), [_Q72_Like] ) as Q72_lib is the category field

but it display a much higher number than 101 698 as it should be :