Forum Discussion

sportive92003's avatar
sportive92003
Icon for Helper II rankHelper II
2 years ago

Switch category

Hello, I have one client X who is in the sector "20%...". I have to eliminate this category and put 33% of the amount in sector "01-..."; 33% in sector "02-..." and 33% in sector "07-...". On the gr...
BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

sportive92003 here:

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

    SWITCH(

        TRUE,

        Fusionner1[Clients.Secteur] = "01 -Machinerie et travaux", A_BNAC,

        Fusionner1[Clients.Secteur] = "02 -Marine et portuaire", B_BNAC,

        Fusionner1[Clients.Secteur] = "03 -Hydroélectrique", C_BNAC,

        Fusionner1[Secteur 20%] = 1, Montant_BNAC,

        Fusionner1[montant])

 

BBF

sportive92003's avatar
sportive92003
Icon for Helper II rankHelper II
2 years ago

Hello again, it's ok when using de RETURN A_BNAC, but adding the switch it come back to the original version. Selecting sector 01, it should appears sector 01 and sector 20% (1/3) like that. In the programmation something is wrong with the switch. Do you have any other solution?