Count when a group of columns of the same table have certain value

[remaster]

Hello guys, I'm really confused because I want to do this...

I have a table with this style

What I need is to Count how many times in a row the words "OutSite(MTY)" or "Rest Day" repeats.

Im looking to achieve this with the following formula

Absences = CALCULATE(
COUNTROWS('dbpenrh emergencypaymentroll'),
SEARCH("OutSite(MTY)",'dbpenrh emergencypaymentroll',1,0))

The problem is that the SEARCH function doesn't "search" in all the table but needs at least 1 column...

Absences = CALCULATE(
COUNTROWS('dbpenrh emergencypaymentroll'),
SEARCH("OutSite(MTY)",'dbpenrh emergencypaymentroll'[Day_1],1,0))

Thats different from what I need.

I need something like a range for the SEARCH that goes from Day_1 to Day_30... 

How can I do this? Is really giving me a bad time ....

Any help is so much appreciated

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, select all columns other than the Day columns > Right click > Unpivot other columns.  Drag Value column to the row labels.  Write this measure

=COUNTROWS(Data)

Hope this helps.

[Anonymous]

Am not sure if this helps.

https://community.powerbi.com/t5/Desktop/Count-based-on-another-column/td-p/422765

[remaster]

it's a different situation, what I'm trying to do is

count 

emergencypaymentroll [Day_1],emergencypaymentroll [Day_2],emergencypaymentroll [Day_3] ..... emergencypaymentroll [Day_30]

when = "OutSite(MTY)"

To get something like this, I think that I need One Measure per Search, but the first thing I need to solve is the search trought all the columns in the table.

OutSite(MTY) ||   3
Rest Day        ||   2
Abscence       ||   1