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 am using this measure to determine variance:
@Anonymous , try like
$ Sale Variance from Fisher =
VAR __Store= "Fisher"
VAR __SaleEach = CALCULATE(SUM('Table'[SumSale]),filter(all('Table'), 'Table'[Store] = __Store))
RETURN
(SUM('Table[SumSale])- __SaleEach )
I am still not getting the expected result 😞 ..any other suggestion?
HI @Anonymous,
Please provide some dummy data to test, it will help for us to test and modify Dax formulas.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
See attached for sample data file. @v-shex-msft @amitchandak @parry2k
Store | $ Sold | $ Sold Variance from Store A | <Expected Result |
A | $22,255.18 | $0 | $0 |
B | $6,643.79 | $6,644 | ($15,611.39) |
C | $2,183.03 | $2,183 | ($20,072.15) |
D | $1,749.00 | $1,749 | ($20,506.18) |
E | $2,693.52 | $2,694 | ($19,561.66) |
F | $2,045.77 | $2,046 | ($20,209.41) |
G | $385.81 | $386 | ($21,869.37) |
H | $823.68 | $824 | ($21,431.50) |
@Anonymous , please find the attached solution. There was a space in A I removed. Not sure it is there in your actual data
@Anonymous Isn't the solution I provided on another post works? What are we missing in that solution? Here is the link to another post.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous still not very clear what stopped working in my original solution. If you can be more specific, provide the sample pbix file with my solution and let me know what is not working, it will help to get you back with the answer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I'm shooting in the dark right now.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |