How to solve Drill Down Different Level

[chandra007]

Hi Team,

How to achive Category, Sales Amount if drill down to show Sub - Product ,Quantity in Same Visuval.

Below attached Image.

Regards,

Chandra

[chandra007]

Am trying to write this measure but am drill down the Sub category but still value is showing Sales Amount

Drill Measure = if(ISINSCOPE(Orders[Sub-Category]), SUM(Orders[Quantity]), SUM(Orders[Sales]))

Need to provide any another query.

[Greg_Deckler]

@chandra007 In theory, create a measure that uses ISINSCOPE or HASONEVALUE and switches between SalesAmoutn and Qty.