Create total column(s) (Like Excel's CountIF() )

[Anonymous]

Hey Power BIs,

I am very new to Power BI and come from Excel. Hi. I have been spending days trying to accomplish what would take me seconds to do in Excel - with zero progress.

I want to create total columns that summarize a long list of columns, counting the number of times a defined text string appears.

Like so:

It puzzles me that something so simple in Excel is seemingly almost impossible in Power BI / query. I must be wrong.

Surely, I'm missing a basic function. Please help!

[Greg_Deckler · Accepted solution]

@Anonymous Yeah, Power BI works better if you unpivot those columns. Then it is trivial. Otherwise, you need to use MC Aggregations: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

[Anonymous]

Just to clarify, I have thousands of columns. Is this still the way? At first glance, that seems like a lot of typing.

[Anonymous]

Hmm.. Interesting.

Thank you.

Funnily enough, this is the unpivoted data. I unpivoted it to establish a relationship with other tables.