Hi Team,
I have two different table but I do not have an relationship with that. But, I need to filter based on the total approved amount.
I need to get the answer for total approved amount based on Sector and Site.
How do I get the ans?
Not possible without relationship.
https://powerbidocs.com/2021/02/10/create-and-manage-relationships-in-power-bi/
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
Hi,
Thank you for your quick reply,
I've multiple table and I already gave a relationship to the other table. While I'm giving replationship to these two table I'm facing a cardinality issues. Because of other relationship with the table. To over come the issues I've tried in-active relationship and gave use relationship function to activate the formula.
Good, What is the problem then?
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
168 | |
88 | |
78 | |
72 | |
67 |