Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rajkumar07
Helper I
Helper I

Need Help

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. 

Rajkumar07_0-1664128127647.png

 

I need to get the answer for total approved amount based on Sector and Site.

How do I get the ans?

3 REPLIES 3
ribisht17
Super User
Super User

@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

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors