Return a single value from multiple rows with SOME identical columns

[Anonymous54321]

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!

[Anonymous · Accepted solution]

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.

[Anonymous54321]

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])