Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.