Forum Discussion
Make a matrix showing the difference between a value and count
Hey guys, I am struggling with this problem. In my dataset I have one table with the product family, date (of sale), month and code: Family Date Month Code A 4/12/20 APR 10 B ...
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!
- Greg_Deckler
Community Champion
Anonymous - 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.