Forum Discussion

MikeHendriks's avatar
MikeHendriks
Icon for Helper I rankHelper I
2 years ago
Solved

Measure based on dividing on types

Hi all,   I have a PBIX file with a fact table with numbers in it. These are linked to dimensions like costcenter.   But now I have an issue with my measure on total level because I have a specia...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

I can’t help you, you better get a new version on your personal computer and see my solution

MikeHendriks's avatar
MikeHendriks
Icon for Helper I rankHelper I
2 years ago

I have downloaded your file Ahmedx. It works I think, but 

SWITCH(TRUE(),
MAX('Costcenter'[Type])="XXO"&&MAX('Costcenter'[SubType])="VXO",0,[Capacity 2 measure])
 
Gives issues in a case where VXO is present, but NXO is not.
  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    in such a case what should we do?

    • MikeHendriks's avatar
      MikeHendriks
      Icon for Helper I rankHelper I
      2 years ago

      If VXO = 80 and NXO is not present -> 80
      If VXO is not present and NXO = 80 -> 80
      If VXO = 80 and NXO = 80 -> 80