Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

help with a basic measure

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 achi...
Need Help
  • zoloturu's avatar
    zoloturu
    6 years ago

    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

zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
6 years ago

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