topic Re: DAX to filter and find the value in DAX Commands and Tips

DAX to filter and find the value

wheelsshark — Mon, 02 May 2022 09:23:13 GMT

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.

Tanushree_Kapse — Mon, 02 May 2022 10:25:00 GMT

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

wheelsshark — Mon, 02 May 2022 22:23:09 GMT

Tanushree_Kapse CAn you help me with the measure please

wheelsshark — Mon, 02 May 2022 22:43:41 GMT

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

Tanushree_Kapse — Wed, 04 May 2022 10:55:25 GMT

Can you please share the pbix. if possible.

v-easonf-msft — Thu, 05 May 2022 03:18:20 GMT

Please edit the inactive relationship as below:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason