Here's a breakdown:
Data Model:
* FactData
* DimProductHierarchy
* DimVersionName1 (disconnected table)
* DimVersionName2 (disconnected table)
Measures:
* [Volume] = SUM(FactData[Volume]
Table Chart1:
Category column - DimProductHierarchy[Level 1]
Value - "Version 1", which is a calculated item I created in Tabular Editor
Table Chart2:
Category column - DimProductHierarchy[Level 1]
Value - "Version 2", which is a calculated item I created in Tabular Editor
Slicer1
Used column - DimVersionName1[Version Name]
Only applied to - Table Chart 1
Slicer2
Used column - DimVersionName2[Version Name]
Only applied to - Table Chart 2
Calculated Items 1 (Version 1):
VAR SelectedVersion1 = SELECTEDVALUE(DimVersionName1[Version Name]) VAR MyFilter = FILTER(ALL(FactData[Version Name]), FactData[Version Name] = SelectedVersion1) VAR Result = CALCULATE(SELECTEDMEASURE(), MyFilter) RETURN Result
Calculated Items 2 (Version 1):
VAR SelectedVersion2 = SELECTEDVALUE(DimVersionName2[Version Name]) VAR MyFilter = FILTER(ALL(FactData[Version Name]), FactData[Version Name] = SelectedVersion2) VAR Result = CALCULATE(SELECTEDMEASURE(), MyFilter) RETURN Result
Other Details:
* FactData and DimProductHierarchy are connected with the Many-to-One relationship.
The Problem:
When I click on a category in Table Chart 1, Table Chart 2 correctly filters to display only that selected category. However, the measure value in Table Chart 2 unexpectedly changes to match the value in Table Chart 1, rather than retaining its original value.
Question:
Can someone help me understand why the measure in Table Chart 2 is getting affected by the interaction with Table Chart 1, and how I can ensure that each visual maintains its own measure value?
0 comments:
Post a Comment
Thanks