Forum Discussion
Solved
Interactive Sum and Variation by Filter
Hi everyone, I import this table in Powe BI: I create several filters on the page: Month, Target, Region... and I want that, when the user select a Month from the filter, Power BI calculates ...
Hi corporate ,
Please check:
1. Create a table.
Month = VALUES('Table'[Month])2. Create a measure.
Difference = VAR SelectedMonth = SELECTEDVALUE ( 'Table'[Month] ) VAR ThisMonth = MAX ( 'Month'[Month] ) VAR SelectedMonthValue = CALCULATE ( SUM ( 'Table'[Contactability] ), 'Month'[Month] = SelectedMonth ) VAR ThisMonthValue = CALCULATE ( SUM ( 'Table'[Contactability] ), 'Table'[Month] = ThisMonth ) RETURN ThisMonthValue - SelectedMonthValue3. Create a Clustered column chart and all slicers from 'Table'.
4. Test.
For more details, please check the attached PBIX file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi corporate ,
Please check:
1. Create a table.
Month = VALUES('Table'[Month])
2. Create a measure.
Difference =
VAR SelectedMonth =
SELECTEDVALUE ( 'Table'[Month] )
VAR ThisMonth =
MAX ( 'Month'[Month] )
VAR SelectedMonthValue =
CALCULATE ( SUM ( 'Table'[Contactability] ), 'Month'[Month] = SelectedMonth )
VAR ThisMonthValue =
CALCULATE ( SUM ( 'Table'[Contactability] ), 'Table'[Month] = ThisMonth )
RETURN
ThisMonthValue - SelectedMonthValue
3. Create a Clustered column chart and all slicers from 'Table'.
4. Test.
For more details, please check the attached PBIX file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
