Forum Discussion
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. ...
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 , if the above solution does not help. Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.