DAX to filter and find the value

[wheelsshark]

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)

RenumerationTable

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.

[wheelsshark]

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

[v-easonf-msft · Accepted solution]

Hi, @wheelsshark 

Please edit the inactive relationship as below:

\

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[wheelsshark]

@Tanushree_Kapse CAn you help me with the measure please

[Tanushree_Kapse]

Hi @wheelsshark ,

Can you please share the pbix. if possible.

[Tanushree_Kapse]

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