Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I used this formula 100 times already and now it seems to not work anymore.
Basically what I do is creating this formula as a start
Market Selected = SELECTEDVALUE('Cost Center'[Market] ; "ESL Group")
So it retrieves the name of the Market I selected, and if nothing is selected then ESL Group.
Then using this next formula allows me to switch between 2 metrics.
Amount MC AC Rates = if([Market selected] = "ESL Group" ; [CHF AC GC Argo CC Integra Argo AY Rates] ; [MC AC CCamount conversion Argo AY Rates])
But the result is always false even if I m sure the Market Selected function is working. (I tested it on a visual)
Any idea if its my mistake or a Bug? Since I used this technic many time it really seems to me that its a bug.
Best regards
Mark Lovejoy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.