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.
Greg_Deckler
Community Champion
Community ChampionAnonymous 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 - __Sales
This makes some assumptions about your visual.
Yep, that's exactly it man!
Thanks a lot for your help!