Need Help

[Rajkumar07]

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?

[ribisht17]

@Rajkumar07 

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

[Rajkumar07]

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. 

[ribisht17]

Good, What is the problem then?