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 |
---|---|
119 | |
75 | |
65 | |
51 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |