Hi @Melissa
I used the 1’s just to check if the SWITCH/TRUE formula itselves was working. And I got the 1’s in the rows where i expected them, so it was working.
But when I replaced the 1’s by the measure I wanted to use, it was not working anymore and returning a blank cell instead of the expected outcome of the measure.
Thanks to this topic Issue /w Switch True
, I have figured out what my problems was. There was an active relationship between the template table and the table with the facts.
Now that I have made some changes to my data-model, this is working fine.
Many thanks!