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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
wheelsshark
Frequent Visitor

DAX to filter and find the value

Hi,

 

I have 3 tables in powerBI, 

1. DateTable

2.RenumerationTable

3.CAlculationsMeasureTable

Relationship is Many to 1 inactive(date-renumeration)

I need to show the Renumeration value based on the year selected - (year is in DateTable)

wheelsshark_0-1651482558645.png

RenumerationTable

wheelsshark_1-1651482604146.png

 

Based on the selection of year from the year table I need to show the card value with renumeration value.

 

I tired to display but it is summarizing and showing the total of Renumeration value. SO i need to create a DAX query to achieve this.

 

1 ACCEPTED SOLUTION

Hi, @wheelsshark 

Please edit the inactive relationship as below:

1.png\

2.png

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

 

View solution in original post

5 REPLIES 5
wheelsshark
Frequent Visitor

The 1- * relationship doesnt work, it says the cardinality you selected isnt valid for this relationship

Hi, @wheelsshark 

Please edit the inactive relationship as below:

1.png\

2.png

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

 

wheelsshark
Frequent Visitor

@Tanushree_Kapse CAn you help me with the measure please

Hi @wheelsshark ,

 

Can you please share the pbix. if possible.

 

 

Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @wheelsshark ,

 

Please create a 1-Many relationship (Active) between your two tables: viz- DateTable- Renumeration Table- 
And then write the measure.

 

 

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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