How to show report drill through value?

[wangjuan303]

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 

[amitchandak]

@wangjuan303 , I am assuming you have a measure like

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

[wangjuan303]

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

[Anonymous · Accepted solution]

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.