Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to Solution.
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 )
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 )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |