topic Re: How do I apply TREATAS or create a virtual relationship? in DAX Commands and Tips

How do I apply TREATAS or create a virtual relationship?

JustinDoh1 — Wed, 14 Jul 2021 19:24:15 GMT

I am trying to apply virtual relationship using TREATAS with the code that I have or modify current code to make it work.

I am sharing my Pbix file here.

I am trying to fix measure called "Col2".

Here is current code:

Expected outcome for Col2 should be 27.333 for Royal T and 79.333 for Royal P (for May 2021).

But, because there is no relationship, outcome just got all mixed up from this table called "Index".

table "Index"

Expected output for May 2021:

Thanks for help!

Re: How do I apply TREATAS or create a virtual relationship?

AlexisOlson — Wed, 14 Jul 2021 20:04:48 GMT

If you're trying to match the Rating in that table, why not something much simpler like

Col2 = IF ( HASONEVALUE ( Main[ProviderName] ), VAR Rating = [Rating] RETURN CALCULATE ( SELECTEDVALUE ( Index[IndexPoint] ), Index[IndexRating] = Rating ) )

or even

Col2 = LOOKUPVALUE ( Index[IndexPoint], Index[ProcessingDate], SELECTEDVALUE ( 'Date Bridge'[ProcessingDate] ), Index[IndexRating], [Rating] )

Re: How do I apply TREATAS or create a virtual relationship?

JustinDoh1 — Wed, 14 Jul 2021 21:16:54 GMT

AlexisOlson It is amazing how you come up with the solution. I appreciated it so much for your help!