cancel
Showing results for
Did you mean:
Member

## COUNTA function in PowerBI on a range of columns

Hi,

I want to make a column in powerBI which counts the cells which are not blank in a range how columns (A, B, C, D)

In excel I would do =COUNTA( A : D )

But how can I make this count in powerbi on a range and not only a single column?

Thanks

Kristoffer

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Established Member

## Re: COUNTA function in PowerBI on a range of columns

You need to use as many counta as necessary in your single measure:

Measure = Counta(Table[Col1]) + Counta(Table[Col2]) + Counta(Table[Col3]) +Counta(Table[Col4])

Or, it is better if you can first unpivot your data using the Query Editor in Power BI Desktop.

Super User

## Re: COUNTA function in PowerBI on a range of columns

Perhaps:

= COUNTA([A]) + COUNTA([B]) + COUNTA([C]) + COUNTA([D])

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

2 REPLIES 2
Highlighted
Established Member

## Re: COUNTA function in PowerBI on a range of columns

You need to use as many counta as necessary in your single measure:

Measure = Counta(Table[Col1]) + Counta(Table[Col2]) + Counta(Table[Col3]) +Counta(Table[Col4])

Or, it is better if you can first unpivot your data using the Query Editor in Power BI Desktop.

Super User

## Re: COUNTA function in PowerBI on a range of columns

Perhaps:

= COUNTA([A]) + COUNTA([B]) + COUNTA([C]) + COUNTA([D])

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,069)