Forum Discussion
corporate
Helper I
Helper IInteractive 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.
Icey
Community Support
Community SupportHi 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.
