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]) )
Hi tamiribas
Can you tell me if your problem is solved? If yes, please accept it as solution.
Regards,
Nono Chen
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])
)- Anonymous2 years agoNot applicable
Hi tamiribas
Thank you very much for your sharing, it will be of great help to others!
Regards,
Nono Chen