Extracting values of 2 measures referring to 2 different slicers

[pkiran]

Hi,

   This is my first post on this forum, so kindly excuse me if I skipped any protocols. 

   I have a fitness related model wherein I need to pick a customer from one slicer and then using the other slicer(having the same list of names as the first slicer but only the col umn duplicated and renamed) to pick any of the other names in the list, my measure must be able to display the two values side by side. I am able to generate the individual cards correctly(Avg_HR_orig and Avg_HR_compn), but when I create variables for the two and the  try to use them in a third measure (check1_HR) to get the 2 outputs side by side, I am able to get only one correct value and not the other.

I have attached the pbix file. Kindly help me out.

Reqt: ex: 108|104->for the Name:Comparison_name combo of Armani Singleton:Bailey Craig

File link-> https://drive.google.com/file/d/12EYHJvg2FCJu7bGrH2PKLOAiCY3nQOiz/view?usp=drive_link

[ERD · Accepted solution]

@pkiran ,

I've made the relashionship inactive and used 2 measures. Both slicers interact with check1_HR card:

Avg_HR_compn = 
VAR c_user = SELECTEDVALUE ( slicer2[Comparison_Name] )
RETURN
    CALCULATE ( [Avg_Heart_Rate], dimUser[Name] = c_user )

Avg_HR_orig = 
VAR c_user = SELECTEDVALUE ( dimUser[Name] )
RETURN
    CALCULATE ( [Avg_Heart_Rate], dimUser[Name] = c_user )

[pkiran]

Hi ERD,

          Thank you very much for the solution. It worked like a charm...just one question though, how did making the relationship inactive enable this? Has this got to do with multiple relationships in the model?? Can you kindly elaborate on this??

Thanks...

[ERD]

You needed to grab the value without filtering this card at the same time. Having active relashionship won't allow this as it will filter the card with different values at the same time. 

[ERD]

Hi @pkiran ,

The file has restricted access.

[pkiran]

Hi,

  Sorry about that...PFB the corrected link...
https://drive.google.com/file/d/12EYHJvg2FCJu7bGrH2PKLOAiCY3nQOiz/view?usp=sharing