Forum Discussion
formula context
Hi Team,
Can you please help me to know that how to apply below formula in Power Bi for a table
Countif(K4:Q29,"<=6")
Hi Ramendra ,
Add an index column in the query editor.
Select the index column and unpivoted other column.
Extract the number after "U".
Converts your selected range to a filter condition in DAX.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Ramendra ,
https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077
CALCULATE(COUNT('Table[ColumnName),FILTER('Table', Table[ColumnName] <= 6))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Anonymous ,
No this is for a range including more than one column.
Can you suggest for this.
Hi Ramendra ,
Add an index column in the query editor.
Select the index column and unpivoted other column.
Extract the number after "U".
Converts your selected range to a filter condition in DAX.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ramendra , if it is one column you can do like
countX(filter(Table,Table[col] <=6),Table[Col])
else Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak , no this is not for a single column.
This is a range of columns in a table.
Can you please suggest for this.
