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