I have the following data in the same source
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. '
Solved! Go to Solution.
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?
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|
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.