Forum Discussion
Solved
Supply True/False for Unique Combination in Rows
Hi, I'm having trouble generating a formula using DAX that will supply me with a unique set of rows that have the same status. Example below: I'm trying to fulfill a DAX formula (cannot be a m...
Hi usergroup113231,
why do you want to do it in DAX? I think Power Query can do it better/easier.
In DAX, if you add an index column, you can do something like this:
if( COUNTROWS(FILTER('Table', EARLIER([Name]) = [Name] && EARLIER([Index])>[Index]))+1 = 1, 1, 0)Cheers,
John
in dax,
CalculatedColumn=CALCULATE(DISTINCTCOUNT(table[Status])=1,ALLEXCEPT(table,table[Submittal]))
Thank you much! Both formulas work like a charm!