Forum Discussion
Using a disconnected table to achieve partial visual interaction
- 2 years ago
Here is a link to a PBIS with the correct functionality.
https://drive.google.com/file/d/1Gh7yBEZcwZJfbQKwgEr5N4DBy7Re3_md/view?usp=drive_link
The date slicer is taken from the disconnected dim table.
The date in the Barchart is taken from the dim date table.
The date in the Matrix is taken from the disconnected dim table.
I adjusted the measure in the Barchart so that :
SalesAmountInBarChart = VAR _MinSelected = MIN('dimDateDisconnected'[YearMonth]) VAR _MaxSelected = MAX('dimDateDisconnected'[YearMonth]) VAR _CalcSales = IF ( SELECTEDVALUE('dimDate'[YearMonth])>=_MinSelected && SELECTEDVALUE('dimDate'[YearMonth])<=_MaxSelected, [SalesAmount],BLANK() ) RETURN _CalcSalesThe measure in the Matrix:
SalesAmountInMatrix = CALCULATE( [SalesAmount], TREATAS( VALUES(dimDateDisconnected[YYYY/MM]), factSales[YYYY/MM] ), ALL(dimDate[YYYY/MM]) )
Here is a link to a PBIS with the correct functionality.
https://drive.google.com/file/d/1Gh7yBEZcwZJfbQKwgEr5N4DBy7Re3_md/view?usp=drive_link
The date slicer is taken from the disconnected dim table.
The date in the Barchart is taken from the dim date table.
The date in the Matrix is taken from the disconnected dim table.
I adjusted the measure in the Barchart so that :
SalesAmountInBarChart =
VAR _MinSelected = MIN('dimDateDisconnected'[YearMonth])
VAR _MaxSelected = MAX('dimDateDisconnected'[YearMonth])
VAR _CalcSales =
IF (
SELECTEDVALUE('dimDate'[YearMonth])>=_MinSelected && SELECTEDVALUE('dimDate'[YearMonth])<=_MaxSelected,
[SalesAmount],BLANK()
)
RETURN
_CalcSales
The measure in the Matrix:
SalesAmountInMatrix =
CALCULATE(
[SalesAmount],
TREATAS(
VALUES(dimDateDisconnected[YYYY/MM]),
factSales[YYYY/MM]
),
ALL(dimDate[YYYY/MM])
)Hi tamiribas
Thank you very much for your sharing, it will be of great help to others!
Regards,
Nono Chen