Calculations

[chwilkinson]

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

[devesh_gupta · Accepted solution]

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