formula context

[Ramendra]

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")

[amitchandak]

@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.

[Ramendra]

@amitchandak , no this is not for a single column.

This is a range of columns in a table.

Can you please suggest for this.

[harshnathani]

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)

[Ramendra]

@harshnathani ,

No this is for a range including more than one column.

Can you suggest for this.

[V-lianl-msft · Accepted solution]

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.

Sample .pbix

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]

@V-lianl-msft,

Thank you for your help.

It was a great idea to unpivot  columns to convert multiple columns in to one and then to apply formula to a final column and I got the expected output as per my requirement.