Same metric shows different values on different tabs

[priyanath1988]

Hi , I have a filter Center id, based on that I am fetching Cetner name. This works fine on the page where filter is define but the same measure does not show then selected value

selected center = 

VAR CenterName =  if(ISBLANK(SELECTEDVALUE(Dim_Centers[CENTER_ID])),"All",CALCULATE(MIN(Dim_Centers[CENTER_NAME])))

RETURN CenterName

but on the different tab selected center shows all.

Could you please see what could be the issue?

Thanks

[priyanath1988]

Thank you @MAwwad for your response. My measure selected center is defined in the same table from where the center id is coming. so I am cwondering why it would not work.

[MAwwad]

It seems that the issue you are facing is related to the filter context being different on the two tabs.

The measure "selected center" is calculated based on the selected value of the "Dim_Centers[CENTER_ID]" column. On the first tab, where the filter is defined, the measure works fine because the filter context is applied to the visual and the "Dim_Centers[CENTER_ID]" column is filtered accordingly. However, on the second tab, the filter context might be different, and the "Dim_Centers[CENTER_ID]" column might not be filtered to the selected value.

To ensure that the measure works consistently across all tabs, you can try adding the "Dim_Centers[CENTER_ID]" column to the filter context of the visual on the second tab. To do this, go to the "Visualizations" pane, select the visual, and drag the "Dim_Centers[CENTER_ID]" column to the "Filters" field. This will ensure that the visual is filtered based on the selected center and the measure "selected center" will show the correct value.

Alternatively, you can also try using the "USERELATIONSHIP" function in the measure to explicitly define the relationship between the "Dim_Centers" table and the fact table used in the visual. This can help to ensure that the filter context is applied consistently across all tabs.

I hope this helps you resolve the issue.