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
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
Hi Anonymous
Would there be a better function rather than using "MAX"? Would sumx be better as it would take the row context?
Hi,
MAX and SUMX are two very different functions. But even MAXX and MAX are very different.
In this specific case you can't use SUMX as it takes a table, rather than a column like MAX.Unfortunately without seeing the model I can't be of more help.