Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct value from multiple columns

Hi All   I'm trying to create a DAX to get the unqiue rate per hour based on two columns - variety and shift. I will need to take this specific value and then use it again in another calculation.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Use a selectcolumns to filter out only the columns that you need

    Budget Rate by Variety = MAXX(DISTINCT(
SELECTCOLUMNS('Variety Budget Data';"Variety";'Variety Budget Data'[Variety];"Shift";'Variety Budget Data'[Shift])), MAX('Variety Budget Data'[Rate Per Hour]))

    SELECTCOLUMNS allows you to filter out only the columns that you need

    There are other solutions, btw

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Use a selectcolumns to filter out only the columns that you need

Budget Rate by Variety = MAXX(DISTINCT(
SELECTCOLUMNS('Variety Budget Data';"Variety";'Variety Budget Data'[Variety];"Shift";'Variety Budget Data'[Shift])), MAX('Variety Budget Data'[Rate Per Hour]))

SELECTCOLUMNS allows you to filter out only the columns that you need

There are other solutions, btw

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Thank you for the reply. I think the formula works, though my Power BI model is giving me headaches as I cannot get the relationships to work.

 

Thanks again