Forum Discussion
Return a single value from multiple rows with SOME identical columns
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!
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.
2 Replies
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.
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])
