Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have 3 tables.
Table 1 (Fact)
Column 1
Org 1
Org 2
Org 3
Org 2
Org 3
Org 1
Org 20
Org 21
Org 22
Org 20
Table 2
Column 1
Org 1
Org 2
Org 3
Org 20
Org 21
Org 22
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
Peers:
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.
Hi there,
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) ???
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |