topic Return a single value from multiple rows with SOME identical columns in DAX Commands and Tips

Return a single value from multiple rows with SOME identical columns

Anonymous54321 — Fri, 24 Nov 2023 23:44:00 GMT

Hello, my 1st time posting here.

Can you please help me create a DAX measure to return Qty required from the data table, disregarding the other 2 columns? If those highlighted columns have identical values, they would also have identical "qty required", I only need it to show once in my report.

I know this can be grouped in Power Query, but my data is connected to a live env. Thank you so much!

Re: Return a single value from multiple rows with SOME identical columns

Anonymous — Sat, 25 Nov 2023 01:13:50 GMT

Hi Anonymous54321 ,

Below is my table:

The following DAX might work for you:

Measure = SELECTEDVALUE('Table'[Status])

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Return a single value from multiple rows with SOME identical columns

Anonymous54321 — Mon, 27 Nov 2023 16:09:20 GMT

I appreciate your help, thank you so much. I realized that this is not really my main problem. I'd like to create a measure (Qty pending which is Qty required - received), and I want the result to be based on the output table. I created this measure and it worked, just not sure if its the best to way to write it 😁

QtyPending= SELECTEDVALUE(Table[qty required])-SELECTEDVALUE(Table[qty received])