The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Microsoft,
I have an exact sceneio of this link https://youtu.be/hu_fOtZDJwU
I could able to create duplicate table and established an inactive relationship and written a DAX code like below
Hi Tamerj1,
Please share the webex/some link to connect with you. Will join the invite
Hi @Anonymous
please check your private messages
@Anonymous
I am extremely sorry. For some reason I did not recieve a notification for this message but only now!
hi @Anonymous
are you even allowed to create the duplicate calendar table or this is also not allowed?
If yes you can do the following
Comparison _abc =
CALCULATE (
[ABC],
INTERSECT (
ALL ( 'Date'[Year], 'Date'[Month Name] ),
SUMMARIZE ( Date_Dup, Date_Dup[Year], Date_Dup[Month] )
)
)
toy might need the change column names or add/remove coulmns base on with coulmns are used for slicing.
Hi Tamerji1,
Thank You for replying!
I have 5 duplicate tables , not only Date table. For eg.,
1. Date_Dup-- Have columns (Month, year, CYYMNN)
2. HSB_Dup--Have columns(HSB_ID)
3. PAM_Dup-- Have columns(PAM_ID)
4. RP_Dup-- Have columns(PA_ID)
5. SU_Dup-- Have columns(STO_ID)
All those columns , I will be passing in a slicer for comparing.
How to pass all of them now?
Hi Tamerji1,
I need to show following output
GDP | abc | comparison_abc | Difference between abc and comparison_abc |
1 | 1000 | 8000 | -7000 |
2 | 3000 | 300 | 2700 |
3 | 3500 | 4000 | -500 |
4 | 500 | 1000 | -500 |
Here abc and comparison_abc are identical measures(same to same )
Hi @Anonymous
Can you please provide some screenshots of your data model and indicate which relationships you wish to create but you're not allowed to.
Hi Tamerji1,
Please find the screenshots attached in a document. Please let me know if you need any other details as well.
Hi @Anonymous
you can the same approach to replace USERELATIONSHIP for all measures.
[Filtered Measure] :=
CALCULATE (
<target_measure>,
INTERSECT (
ALL (
<target_granularity_column_1>,
<target_granularity_column_2>
),
SUMMARIZE (
<lookup_table>
<lookup_granularity_column_1>
<lookup_granularity_column_2>
)
)
)
However, this really depends on how your report is.
if you wish you can share a sample no sensitive data file with one to cases I'll help you out with them
Hi tamerj1,
Is there any way , to connect with you. So that I can share my screen and explain you.
Hi @Anonymous
Would be possible only on next Saturday.
Hi Tamerj1,
Sure, Thank you 🙂
Hi Tamerj1,
Hope we are connecting on Saturday. Is there a way/link and Time so that I can be ready with files .
Hi Tamerj1,
Sure, Thank You
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |