The MEASURE can't calculate GRAND TOTAL value in the table

[Anonymous]

Dear All,

I would like to kindly ask you for help.
My measure (Measure_1) calculates values correctly in the rows
but can't calculate grand total in the table.

Mesure_1 =
VAR CurrentKlientID = SELECTEDVALUE ( 'Table_1' [Klient_ID])
RETURN
MAXX (

            FILTER (

                         ALL ( 'Table_1'); 'Table_1' [Klient_ID] = CurrentKlientID);
                                      ('Table_1'[Revenue] ) )

Present Results
Klient_ID | Measure_1 |
---------------------------
12John   | 100            |
10Tom   | 50               |
3Anna    |20               |

===================

             no TOTAL value should be 170

Regards,

[parry2k]

@Anonymous because it is a poor data model, do you have a separate dimension for the client?

[Anonymous]

Parry2k, unfortunatelly volume of unique clients exceeds one milion.
The cardinality of  Client_ID is vey high.

Preview

[parry2k · Accepted solution]

@Anonymous try this measure:

Mesure_1 =

SUMX(
VALUES (   'Table_1' [Klient_ID] ),
CALCULATE ( MAX ( 'Table_1'[Revenue] ) )
)

✨ 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.⚡

[Anonymous]

Thank you very much.
The measure works correctly (calculate the grand total) but a lot of memory is needed to calculate over millions records.