Sum values when they match a condition format

[murilosoldi]

Hello everyone!

I tried a lot of different methods to get this sum done but could not succeed so far. I've tried summarize table, earlier function, calculate and so on.

The conditional format for the cell backgroud is defined by: if the price is lower than a minimum price, let it be orange. Simple as that.

Therefore, what I basically  need is to have a calculated column that sums the number of orange cells  every row. As the pictures says, I'd like to have the "OrangeDays" column counting how many cells are orange in each row.

 So, for example, the result for the first row should be OrangeDays = 3 and for the last two rows, OrangeDays should be 4. 

Any ideas on how to solve this? I've tried a lot of different things but not being able to put a measure on the columns of a matrix is bugging me for real. 

Thanks a lot in advance!
All the best, 

Murilo 

[Greg_Deckler]

@murilosoldi You will need to use SUMMARIZE or GROUPBY to group your rows by your columns, use ADDCOLUMNS or within the SUMMARIZE to calculate your value. You can then use another ADDCOLUMNS to count the number of OrangeDays. Hard to be specific.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[murilosoldi · Accepted solution]

Hello Greg, thanks for your reply!

I sliced a bit of the data so you can see its structure on the image below:

I'm taking a deeper look on summarize + addcolumns, this might actually solve this problem. 

Thanks in advance!

Kind regards,

Murilo