help with a basic measure

Question

Hi Experts!!&nbsp;Need help with what i think should be a basic measure.&nbsp;&nbsp;I want to create 2 measure, (examples below)...&nbsp;I have put the explanation of what i would like each measure to achieve.&nbsp;Thanks in advance, guys.&nbsp;&nbsp;&nbsp;if data 1 = 1 or 2 or 3 = "A", if not = blankif data 1 = 4 or 5 or 6 = "b", if not = blankdata1&nbsp;measure 1measure 21A&nbsp;2A&nbsp;3A&nbsp;4&nbsp;B5&nbsp;B6&nbsp;B

zoloturu · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;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 &amp; 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

Forum Discussion

help with a basic measure

1 Reply

Related content

Basics Of Filter

Basic DAX Issue

Need help with a basic new measure

Basic previous year measure

Gateway Connection - basic authentication

	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