Need help with Totals

[Anonymous]

Hey Guys,

I know the totals in Power BI have been discussed several times, yet I'm posting this simply because I still don't understand it.

I have this table with several measures, and the total simply doesn't work.

Below are formulas of the first two columns:

# Digitaal JA E-mail Bekend = CALCULATE(

    DISTINCTCOUNT('Totaaloverzicht Fondsen'[cldeeln.Naw.Naw-Polisnummer]),

    FILTER('Totaaloverzicht Fondsen','Totaaloverzicht Fondsen'[Type E-mail] = "Bekend"),

    FILTER( 'Totaaloverzicht Fondsen', 'Totaaloverzicht Fondsen'[maia.Persoon.flDigitaalCommuniceren]=TRUE()))

% Digitaal Ja E-mail Bekend = [# Digitaal JA E-mail Bekend]/[Totaal]

Totaal = COUNT('Totaaloverzicht Fondsen'[cldeeln.Naw.Naw-Polisnummer])

Would appreciate if someone could explain this to me.

With kind regards,

Lazzanova

[Anonymous]

@v-xinruzhu-msft You are right, I did add the wrong printscreen it seems...

Here is the correct one. 

The total of # Digitaal Ja E-mail Bekend is incorrect.
The formula for this measure is:

# Digitaal JA E-mail Bekend =

CALCULATE(

    DISTINCTCOUNT('Totaaloverzicht Fondsen'[cldeeln.Naw.Naw-Polisnummer]),

    FILTER('Totaaloverzicht Fondsen','Totaaloverzicht Fondsen'[Type E-mail] = "Bekend"),

    FILTER( 'Totaaloverzicht Fondsen', 'Totaaloverzicht Fondsen'[maia.Persoon.flDigitaalCommuniceren]=TRUE()))


So I 'm guessing I need to squeeze in SUMX somewhere in the DAX formula. Could you help me out?

[v-xinruzhu-msft]

Hi @Anonymous 

You can refer to the information I offered above.You can create a new measure

e.g  

Note:For the example, I add a name to your first column.

Measure=SUMX(VALUES('Totaaloverzicht Fondsen'[Type]),[# Digitaal JA E-mail Bekend])

Best Regards!

Yolo Zhu

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

[v-xinruzhu-msft]

Hi @Anonymous 

It is not known from the picture you provided which total you are referring to does not work

If you are referring to the [% Digitaal Ja E-mail Bekend] sum, perhaps you can refer to the following measures

Note:For the example, I add a name to your first column.

% Digitaal Ja E-mail Bekend = SUMX(VALUES('Totaaloverzicht Fondsen'[Type]),[# Digitaal JA E-mail Bekend]/[Totaal])

Best Regards!

Yolo Zhu

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