Forum Discussion
Solved
3#DAX : FIND ROW NUMBER BASED ON CRITERIA
Hi Experts
Reaching out again for the DAX formula to arrive at calcuated formula to find the row number based on Criteria. For example Attrribute is valid if the marked as "Yes" in the source data table.
Required in DAX a calcuated column which will find the row number in serial where there is criteria is matched.
I tried with calcuate( count(), filter())) but believe my filter context is not correct.
Normal Excel formula
'=IF($C2="Yes",ROW(A2),"")
| Type | Attribute | Is Valid | normarl excel ( cell reference) | can we have inDAX | DAX Function | |
| A | A1 | Yes | 2 | 1 | ?? | |
| A | A2 | Yes | 3 | 2 | ||
| A | A3 | |||||
| A | A4 | |||||
| A | A5 | Yes | 6 | 3 | ||
| A | A6 | Yes | 7 | 4 | ||
| A | A7 | Yes | 8 | 5 |
May be you can use this Column
Column = VAR myrank = RANKX ( FILTER ( TableName, TableName[Is Valid] = "Yes" ), TableName[Attribute], , ASC, DENSE ) RETURN IF ( TableName[Is Valid] = "Yes", myrank )
2 Replies
Not understanding what you are going for here but I can say that you probably need to add an Index column in Power Query to your query.
May be you can use this Column
Column = VAR myrank = RANKX ( FILTER ( TableName, TableName[Is Valid] = "Yes" ), TableName[Attribute], , ASC, DENSE ) RETURN IF ( TableName[Is Valid] = "Yes", myrank )
