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.
My first column contains is "Yes/No" containing "Yes/No" values.
My second column is Dollars (this is a measure.)
I would like to create a measure that represents: Yes Dollars - No Dollars
But I'm getting kludgey and chasing my tail with my filter then subtract. Any boost on how to achieve this elegantly?
Much thanks!
Bah, re-presenting to improve clarity:
My first value is a column that contains "Yes/No" values.
My second value is a measure of a weighted average of Amount.
I would like to create a measure that represents Yes Amount - No Amount = Yes/No Amount Difference.
Please share example data and desired output so a specific expression can be suggested.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
=calculate(sum(table[amount],table[yes/no]="yes")-calculate(sum(table[amount],table[yes/no]="no")
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |