Blank Values in Drill Up Option

[Khizer28]

Hello,

I am using "Matrix" chart in Power BI but the values are appearing as Sum when I select Drill Up. 

Attached is the image of current scenerio

I want blank values in Drill Up as appearing in the below attached image

[v-eqin-msft]

Hi @Khizer28 ,

You could use ISFILTERED(), ISINSCOPE(), HASONEVALUE() like this:

Measure = IF(HASONEVALUE('Table'[Sub]),MAX('Table'[ID]),"")

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

[amitchandak]

@Khizer28 , not very clear. In case you want header is blank. Then you need to blank the header.  Means a column with blank values at top.

If you need to deal with values hen you can use isinscope

[Khizer28]

Hey Amit,

I have tried the link which you shared but it doesnt give the final result what actually I want. But still thank you for your sharing