Forum Discussion

jtpiazzamn's avatar
jtpiazzamn
Helper I
3 years ago
Solved

Measure not returning a value

I have a measure using SWITCH but its not returning a value. So I simplified it and its still not working. The strange thing is I have the same measure on a different PowerBI file and it works fine....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jtpiazzamn ,

     

    I made an example for your reference.

    As you can see, the SELECTEDVALUE function returns blank. Because the SELECTEDVALUE function returns the value when the context for columnName has been filtered down to one distinct value only.

    If you select an ID in the slicer, the measure in the card visual returns value. 

    If the slicer doesn't select it, you put the measure into a visual with context, and the measure returns value.

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jtpiazzamn ,

 

I made an example for your reference.

As you can see, the SELECTEDVALUE function returns blank. Because the SELECTEDVALUE function returns the value when the context for columnName has been filtered down to one distinct value only.

If you select an ID in the slicer, the measure in the card visual returns value. 

If the slicer doesn't select it, you put the measure into a visual with context, and the measure returns value.

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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