CODEWITHSUNDEEP
powerbidaxpowerbi-desktopdaxstudio
sam
sam

Reputation: 1304

Allselected not working as it should and is giving wrong output

I need to create a measure to find the max date from the column : ads_actualenddate based on the name column. Below is the sample data and sql query. It's easy to do this in SQL but I am not able to implement it in DAX:

enter image description here

I am trying to implement this solution in power BI using ALLSELECTED because there are slicers that need to taken care of. All the columns in where clause will be my slicers in power BI

enter image description here

After adding the measure the rows have increased. In reality there should be only two rows.

If I remove my measure the data is as follows:

enter image description here

The measure should give me "2025-05-23 22:00:00.0000000"

Any help here will be appreciated. Thank you in advance

Upvotes: 0

Views: 26

Answers (0)

Related Questions