I have 3 tables.
Table 1 (Fact)
Table 3 Peers
Column 1 Column 2
Org 1 Org 20
Org 1 Org 21
Org 1 Org 22
Org 2 Org 20
Org 2 Org 22
Org 3 Org 20
Org 3 Org 21
I have a few measures created in Table 1.
Reporting requirement is like below :
In one visualisation, I need to show
Select Org : Org 1
Name of Org : Org 1 Value of Measure 1
Name of Peer Org : Org 20 Value of Measure 1
Name of Peer Org : Org 21 Value of Measure 1
Name of Peer Org : Org 22 Value of Measure 1
How do I achieve this using DAX?
Any help is appreciated.
It seems that you may just add relationship and use table visuals.
Thanks for your reply.
Could you please explain which relationships do I need to create?
Table 1 > Table 2 (M : 1)
Table 2 > Table 3 (1 : M)
Table 3 > Table 1 (M : M) ???
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!