Forum Discussion

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.