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. I believe I have a relatively simple ask but one that I cannot figure out.
I have included a link to a sample dataset. https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/EZt6qdxeDXhJpZjw3Jaay4wBe5-VaTaxIwgjy...
I have three tables: dimension for SHAPES, dimension for COLORS, and a fact for SALES. I know how to make measures for when color="Red" or when shape = "Round" or when color=Red AND shape="Round" but I need to create a measure for when color="Red" OR shape="Round"
Any help would be most appreciated! Thank you so much!
@CALCULATE, @ORlogic
Solved! Go to Solution.
Hi @dkernen - have you tried adding the separate results of "where color = red" and "where shape = round" ? This would double-count those that are red and round, so you could then subtract "where color = red AND where shape = round".
RedOrRound =
var __Red = CALCULATE([Total Sales], Colors[Color] = "Red")
var __Round = CALCULATE([Total Sales], Shapes[Shape] = "Round")
var __RandR = CALCULATE([Total Sales], Colors[Color] = "Red", Shapes[Shape] = "Round")
return
(__Red + __Round) - __RandR
Hope this helps
David
Hi @dkernen - have you tried adding the separate results of "where color = red" and "where shape = round" ? This would double-count those that are red and round, so you could then subtract "where color = red AND where shape = round".
RedOrRound =
var __Red = CALCULATE([Total Sales], Colors[Color] = "Red")
var __Round = CALCULATE([Total Sales], Shapes[Shape] = "Round")
var __RandR = CALCULATE([Total Sales], Colors[Color] = "Red", Shapes[Shape] = "Round")
return
(__Red + __Round) - __RandR
Hope this helps
David
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |