Multiple IF functions with filter

Hi,

Try uisng SWITCH + TRUE to achieve this. The basic structure is as follows: SWITCH(TRUE(),condition1, result1,
condition2, result2 ...
)

To get this to show in matrix I recommend creating a new table e.g. Table = {("Low"),("Medium"),("High"),("Top")}

Then use this table in comination with your category measure to get the desired end result.

E.g. Filter = If(Table[Value]=[Measure],1,0)

Place this as a visual filter to enable slicing based on category. (Filters on this visual: Filter is 1)

Then you can create e.g. count measures to get values based pn category:

Bool High = IF([Measure]="High",1,0)

Count high = SUMX(orders,[Bool high])

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/