Forum Discussion

Ramendra's avatar
Ramendra
Icon for Helper IV rankHelper IV
6 years ago
Solved

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")
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    Ramendra
    Icon for Helper IV rankHelper IV
    6 years ago

    amitchandak , no this is not for a single column.

    This is a range of columns in a table.

    Can you please suggest for this.