Forum Discussion
WishAskedSooner
2 years agoContinued Contributor
Highlighting Selected Column in a Bar Chart Problem
I know this is a fairly common request and the Youtube video below works as expected: https://www.youtube.com/watch?v=FnEKyhSf2mM However, there is one big caveat. On my report, I have numerous vi...
- 2 years ago
I found the solution:
CALCULATE(SUM('Fact'[Val]), ALL('Prod'), 'Prod'[ID] = 1, ALL('DimDates'[Month]), TREATAS(VALUES('UnDimDates'[Month]), 'DimDates'[Month]))
WishAskedSooner
2 years agoContinued Contributor
I found the solution:
CALCULATE(SUM('Fact'[Val]), ALL('Prod'), 'Prod'[ID] = 1, ALL('DimDates'[Month]), TREATAS(VALUES('UnDimDates'[Month]), 'DimDates'[Month]))