topic Re: Extracting values of 2 measures referring to 2 different slicers in DAX Commands and Tips

Extracting values of 2 measures referring to 2 different slicers

pkiran — Thu, 03 Aug 2023 18:36:45 GMT

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

Re: Extracting values of 2 measures referring to 2 different slicers

ERD — Thu, 03 Aug 2023 19:18:55 GMT

Hi pkiran ,

The file has restricted access.

Re: Extracting values of 2 measures referring to 2 different slicers

pkiran — Fri, 04 Aug 2023 03:27:18 GMT

Hi,

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

Re: Extracting values of 2 measures referring to 2 different slicers

ERD — Fri, 04 Aug 2023 06:35:28 GMT

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 )

Re: Extracting values of 2 measures referring to 2 different slicers

pkiran — Fri, 04 Aug 2023 10:49:42 GMT

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...

Re: Extracting values of 2 measures referring to 2 different slicers

ERD — Fri, 04 Aug 2023 13:32:49 GMT

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.