Forum Discussion
Make a matrix showing the difference between a value and count
Anonymous What about a measure like:
Measure = VAR __Month = MAX('Forecast'[Month]) VAR __Family = MAX('Forecast'[Family]) VAR __Forecast = MAX('Forecast',[Value]) VAR __Sales = COUNTROWS(FILTER('Sales',[Month]=__Month && [Family]=__Family)) RETURN __Forecast - __SalesThis makes some assumptions about your visual.
I am trying to upload my pbi file but couldn't find the right way to do it!
Community ChampionAnonymous - Seems doable but missing a value column of sales in first table? To share a PBIX, put it on OneDrive or Box or something and share a public link to it.
Greg_Deckler Actually, it is not missing anything because it doesn't matter actually the value of the sales, just the amount of sales for each family, the column "vsalue" on the second table goes for the number of sales.
Here it goes the link: https://drive.google.com/file/d/15-GewmUTetS3-klGVHzabqKl4tUkZnmt/view?usp=sharing- Greg_Deckler
Anonymous What about a measure like:
Measure = VAR __Month = MAX('Forecast'[Month]) VAR __Family = MAX('Forecast'[Family]) VAR __Forecast = MAX('Forecast',[Value]) VAR __Sales = COUNTROWS(FILTER('Sales',[Month]=__Month && [Family]=__Family)) RETURN __Forecast - __SalesThis makes some assumptions about your visual.
Yep, that's exactly it man!
Thanks a lot for your help!
- Ashish_Mathur
Super User
Hi,
That link does not work. Show the expected result very clearly.
