Forum Discussion

J_R_Cribb's avatar
J_R_Cribb
Helper I
9 years ago
Solved

Remove Measure at Drill Down level?

Hello All,    I have a matrixwhereby I am showing Revenue & Forecast Revenue which can be filtered by month.   I would like to be able to drill down from Account Manager, to Customer, to Product,...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi J_R_Cribb,

     

    Based on my test, you should be able to use the formula below to create a new measure to calculate Budget for Customer and Product accordingly, and show the measure instead of the Budget column on the Matrix in your scenario.

    Measure for Budget = IF ( HASONEVALUE ( 'Product'[Product] ), 0, SUM ( Budget[Budget] ) )

    Here is the modified pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi J_R_Cribb,

 

Based on my test, you should be able to use the formula below to create a new measure to calculate Budget for Customer and Product accordingly, and show the measure instead of the Budget column on the Matrix in your scenario.

Measure for Budget = IF ( HASONEVALUE ( 'Product'[Product] ), 0, SUM ( Budget[Budget] ) )

Here is the modified pbix file for your reference. :smileyhappy:

 

Regards