Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HELP! How to create non-mutually exclusive categories?

Dear Power Bi commuity, I need help to create non-mutually exclusive categories. So here I have made an example of how I need different rows to go into different categories.  So e.g. a row w...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Seems like you need a disconnected table for your categories. Use this for your x-axis. Then you can write the measure accordingly. For example:

 

Measure = 
  VAR __Category = MAX('Disconnected Table'[Category])
  VAR __Result =
    SWITCH(TRUE(),
      __Category = "Handy", SUMX(FILTER('Table', [Category] = "Handy"),
      __Category = "MR", SUMX(FILTER('Table', [Category] = "MR"),
      __Category = "LR1", SUMX(FILTER('Table', [Category] = "LR1"),
      __Category = "LR1 + Paramax", SUMX(FILTER('Table', [Category] = "LR1") + SUMX(FILTER('Table', [Category] = "Paramax"),
      __Category = "LR2", SUMX(FILTER('Table', [Category] = "LR2"),
      __Category = "LR2 + Paramax", SUMX(FILTER('Table', [Category] = "LR2") + SUMX(FILTER('Table', [Category] = "Paramax"),
      __Category = "Paramax", SUMX(FILTER('Table', [Category] = "Paramax"),
      __Category = "Aframax", SUMX(FILTER('Table', [Category] = "Aframax")
    )
RETURN
  __Result

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Greg,

Thank you for taking the time to answer me.

I am not familiar with disconnected tables and I don't know how to implement your solution. I tried making a new table, but it does not work. Can you maybe help by explaning exactly how and where I should implement this code?

Thank you in advance!

Sincerely, Signe