help with a basic measure

[Anonymous]

Hi Experts!! 

Need help with what i think should be a basic measure.  

I want to create 2 measure, (examples below)... 

I have put the explanation of what i would like each measure to achieve.

Thanks in advance, guys. 

	if data 1 = 1 or 2 or 3 = "A", if not = blank	if data 1 = 4 or 5 or 6 = "b", if not = blank
data1	measure 1	measure 2
1	A
2	A
3	A
4		B
5		B
6		B

[zoloturu · Accepted solution]

Hi @Anonymous ,

Measures:

Measure 1 = 
VAR __data =
    MAX ( 'Table'[data1] )

RETURN
    SWITCH ( __data, 
    1, "A", 
    2, "A", 
    3, "A", 
    BLANK () 
)

Measure 2 = 
VAR __data =
    MAX ( 'Table'[data1] )

RETURN
    SWITCH ( __data, 
    4, "B", 
    5, "B", 
    6, "B", 
    BLANK () 
)

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups