Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculations

Hello,

I'm quite new to power BI and so could really do with some help with calculations.

I an using SP as a data source and have a column with valuses of high, medium and low.

I'd like to work of the number of rows with eith high, medium or low in the column but I'm struggling to work out how to do it.

Any help would be really appreciated.

Thanks

Need Help
Tips and Tricks
Tutorial Requests
  • devesh_gupta's avatar
    devesh_gupta
    2 years ago

    Anonymous Yeah, you can simply create three measures for counting the number of rows for the high, medium and low respectively.

    Like this: 

    high = COUNTROWS(FILTER('Table', 'Table'[columnName] = "high"))

medium = COUNTROWS(FILTER('Table', 'Table'[columnName] = "medium"))

low = COUNTROWS(FILTER('Table', 'Table'[columnName] = "low"))

     

    If you find this insightful, please provide a Kudo and accept this as a solution.

1 Reply

  • devesh_gupta's avatar
    devesh_gupta
    Impactful Individual
    2 years ago

    Anonymous Yeah, you can simply create three measures for counting the number of rows for the high, medium and low respectively.

    Like this: 

    high = COUNTROWS(FILTER('Table', 'Table'[columnName] = "high"))

medium = COUNTROWS(FILTER('Table', 'Table'[columnName] = "medium"))

low = COUNTROWS(FILTER('Table', 'Table'[columnName] = "low"))

     

    If you find this insightful, please provide a Kudo and accept this as a solution.