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.
I have the following data in the same source
Status Qty
P 10
P 20
M 50
M 30
C 25
I want to create a messure that SUMs the qty's but only for status P. I know how to do it with a SUM and a filter on a viz but I was hoping to create a meassure as this type of calc will be used in many cards and other queries. '
Thanks
Solved! Go to Solution.
Measure = CALCULATE(SUM(TableName[Qty]), TableName[Status]="P")
Hope this helps!
What if I want to sum for more than one status? How do I do?
What if I wish to get the sum of quantity for P as well M status but not C? How should I do it?
i can't make this "Create a SUM measure that sums conditionally (based on a value in another column)" in if condition. could anyone Know the solution for this? Please share the syntax.
I have a simmilare issues
what i would liek to do is show all values P, M, C in a chart and show the sum of all Qty assosated to them.
can this be done without having to create a Mesure for every Status?
@nehabarnwal @Colinu @brett_walton @Sean
You can try the following to Group By elements that are in your rows:
e.g.
MyMeasureByGroup =
CALCULATE(
SUM('MYTABLE'[COLUMN1]),
GROUPBY('MYTABLE', [COLUMN2])
)
Hi,
I have the following situation.
How could I sum the figures in column 2 by taking only one amount per each value in column 1?
By example, for value 3, I should have an average of the amounts displayed in column 2 and add it to the average amount for value 2 and so on.
Column 1 | Column 2 |
3 | 10,00 € |
3 | 10,00 € |
3 | 50,00 € |
2 | 10,00 € |
1 | 2,00 € |
2 | 3,00 € |
3 | 45,00 € |
Thank you!
It does , thanks for share with the beginner.
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.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |