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
MikeHendriks's avatar
MikeHendriks
Icon for Helper I rankHelper I
2 years ago

Hi Ahmedx,

 

Thank you for your quick response! This seems to work for the data that is in the example, but I saw on your code that it's not working for cases where only VXO is present (and NXO is not). I've added that case to https://easyupload.io/1j4mpj with costcenter 567.

 

Is there an option which is working not with an approach where VXO is not calculated, but just 1 value for VXO and NXO when both are present. They will by the way always be equal.

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