Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Power BI Community Support,
I am new to the power bi looking for support for the below problem statement.
This is a semple of my table:
Calls | Time |
Delivered | 30 |
Abandoned | 15 |
Abandoned | 25 |
so I need to sum column *(Time ) when Abandoned I tried it:
I hope the problem statement is clear and looking forward support.
thanks!
Solved! Go to Solution.
This is generally done with filters like this:
CALCULATE ( SUM ( 'Table1'[Time] ), 'Table1'[Calls] = "Abandoned" )
This is generally done with filters like this:
CALCULATE ( SUM ( 'Table1'[Time] ), 'Table1'[Calls] = "Abandoned" )
It works, thank you so much
Hi:
Do you have any particular figures? In general, if you look at the file in this link (very basic) it shows a calculated column in the table CityRev. That has conditions. Those are to add up up the sales in that particular city on any particular day.
The is also a measure named Ciy 1 Sales , that has a condition too. It is taking the [Total Sales] measure and applying a condition to it that says only calculated total sales for the City coded 1.
Does this help?
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |