3#DAX : FIND ROW NUMBER BASED ON CRITERIA

[_google]

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

[Greg_Deckler]

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.

[Zubair_Muhammad · Accepted solution]

@_google

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 )