Forum Discussion
SUMMARIZE Table
Hi Guys.
I have the following SUMMARIZE table:
The report was working fine. Issue is, Thiess Classification now seem to have repeated values. And because of that, I can't make One-Many Relationship. Is there a way to resolve this? (I can't delete the repeated values as I would require them)
Thanks for the input guys.
Bridge was an option yes, but I was able to combine columns to make it a unique identifier. This did the trick for me.
5 Replies
solution is to create a new bridge table that will have the unique values only or create a composite key in you table with the help of the combination that will have the unique values.
If this helped, Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
https://instagram.com/analytic_pulse
https://analyticpulse.blogspot.com/subscribe to Youtube channel For fun facts:
https://www.youtube.com/@CogniJourneyread about Using fact tables as a bridge
read 167page in Analyzing_Data_with_Power_BI
Thanks for the input guys.
Bridge was an option yes, but I was able to combine columns to make it a unique identifier. This did the trick for me.
Please subscribe CogniJourney On Youtube For fun facts:
https://www.youtube.com/@CogniJourney
Help me grow.
ThanksPlease subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney
