I am using this measure to determine variance:
@ThePowerBIQueen , try like
$ Sale Variance from Fisher =
VAR __Store= "Fisher"
VAR __SaleEach = CALCULATE(SUM('Table'[SumSale]),filter(all('Table'), 'Table'[Store] = __Store))
(SUM('Table[SumSale])- __SaleEach )
Please provide some dummy data to test, it will help for us to test and modify Dax formulas.
|Store||$ Sold||$ Sold Variance from Store A||<Expected Result|
@ThePowerBIQueen 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.
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications
Features releasing from October 2020 through March 2021