Switch works in power pivot but not in Power Bi

[ChrisMed]

Hello,

Looking for a solution for this.

I made my model in Power pivot, then loaded it into PBI.

In Excel, my switch measure works fine, and the measures in the switch funtion appear in the pivot table in the appropriate places.

In PBI, when I select a matrix to diplay the data, all the data appears correctly, apart from the some of rows that are concernd by the switch function, these appear blank(in red in the below measure)

The measures not appearing in the matrix are all division( Divide)

If I put the measures concerned by the switch in a Card, they work fine.

Here is the measure

Reprev = CALCULATE(SWITCH(MAX(TABLIBHYPFINAL[LIBELLE N°]);126;[Effectif Present];127;[Ca Net/Effectif];128;[Stocks];129;[Clients];130;[Fournisseurs];131;[BFR];132;[MS/VA];133;[PDM];138;[Heures MO];[Montant New Sum]);AUTO_DOM_HR[SCENARIO]="Forecast")

Any ideas?

Thanks.

[v-shex-msft]

Hi @ChrisMed,

Maybe you can try to define a variable to store switch condition, then direct use that variable in calculate:

Reprev =
VAR switchMeasrue =
    SWITCH (
        MAX ( TABLIBHYPFINAL[LIBELLE N°] );
        126; [Effectif Present];
        127; [Ca Net/Effectif];
        128; [Stocks];
        129; [Clients];
        130; [Fournisseurs];
        131; [BFR];
        132; [MS/VA];
        133; [PDM];
        138; [Heures MO];
        [Montant New Sum]
    )
RETURN
    CALCULATE ( switchMeasrue; AUTO_DOM_HR[SCENARIO] = "Forecast" )

If above not help,  can you please share some sample data for test?

Regards,

Xiaoxin Sheng