Forum Discussion

wangjuan303's avatar
wangjuan303
Icon for Helper III rankHelper III
4 years ago
Solved

How to show report drill through value?

Hi Everyone, I have a drill through page, I can show drill through value one the top , it will looks like this,  but when my matric this column have multiple values, this Drill through value w...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi wangjuan303 ,

     

    As far as I know VALUES function will return a table based on your selection. However measure will return a single aggregate value. So when you only select one value you will get result and you couldn't get result when you get multiple values, even get error.

    Here I suggest you to try CONCATENATEX function to combine all values return by VALUES function.

    M_SAG =
IF (
    ISFILTERED ( 'Table'[sag] ),
    "SAG : " & CONCATENATEX ( VALUES ( 'Table'[sag] ), [sag], "/" ),
    BLANK ()
)

     

    Best Regards,
    Rico Zhou

     

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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

wangjuan303 , I am assuming you have a measure like

 

SAG = IF(ISFILTERED(Table[sag], "SAG : "&selectedvalue('Table'[sag]), Blank())

  • wangjuan303's avatar
    wangjuan303
    Icon for Helper III rankHelper III
    4 years ago

    Test it, selectedvalue or Max all show blank too, Thank you 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi wangjuan303 ,

       

      As far as I know VALUES function will return a table based on your selection. However measure will return a single aggregate value. So when you only select one value you will get result and you couldn't get result when you get multiple values, even get error.

      Here I suggest you to try CONCATENATEX function to combine all values return by VALUES function.

      M_SAG =
IF (
    ISFILTERED ( 'Table'[sag] ),
    "SAG : " & CONCATENATEX ( VALUES ( 'Table'[sag] ), [sag], "/" ),
    BLANK ()
)

       

      Best Regards,
      Rico Zhou

       

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