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 will show blank ,

for example, here if Drill through to Deri, will show right value, if Drill through to SFT, will show blank, 

when we drill through to anyone, page drill through always show right drill through information : 

my related code is 

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

 

Looks code show SAG value as blank, maybe because matric on that row show SAG blank,

Is anyone know how to fix code to show filter value? Thank you 

 

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.

     

3 Replies

  • 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.