calculate or switch?

sportive92003 — Mon, 29 Jul 2024 18:55:09 GMT

Hello,

In the formula, the first CALCULATE after the RETURN gives the results, but I can't reproduce for the 2 seconds CALCULATE. Any solution? Seems so easy but I can't reach.

Secteur_BNAC =

VAR A = CALCULATE([Montant Measure],Fusionner1[Clients.Secteur ] = "01 -Machinerie et travaux")

VAR B = CALCULATE([Montant Measure],Fusionner1[Clients.Secteur ] = "02 -Marine et portuaire")

VAR C = CALCULATE([Montant Measure],Fusionner1[Clients.Secteur ] = "03 -Hydroélectrique")

VAR Montant_BNAC = IF('Fusionner1'[Secteur 20%] = 1, 'Fusionner1'[montant] / 3, BLANK() )

VAR A_BNAC = (A+Montant_BNAC)

VAR B_BNAC = (B+Montant_BNAC)

VAR C_BNAC = (C+Montant_BNAC)

RETURN

CALCULATE(A_BNAC,'Fusionner1'[Clients.Secteur ] = "01 -Machinerie et travaux")

/*CALCULATE(B_BNAC,'Fusionner1'[Clients.Secteur ] = "02 -Marine et portuaire")

CALCULATE(C_BNAC,'Fusionner1'[Clients.Secteur ] = "03 -Hydroélectrique")*/

And for others sectors, just use the amount (Montant Measure).

Thanks.

Re: calculate or switch?

MattAllington — Mon, 29 Jul 2024 22:10:34 GMT

Variables in DAX are not variable. It would be better if they were called constants. Once you assign a value it cannot be changed. As a result, you cannot use variables as the first parameter inside CALCULATE as that parameter is the one that is modified by the filter parameters.

topic Re: calculate or switch? in DAX Commands and Tips

calculate or switch?

Re: calculate or switch?