Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculation for one single level

Hi everyone   I have for tables: Invoice: Product + Qty Product: Product + Product Group Product Group: Product Group Budget: Product Group + Budget   Summarizing: Sales by Products and Budge...
Need Help
  • Datatouille's avatar
    Datatouille
    8 years ago

    Hi Ana,

     

    Try this measure:

     

    Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )

     

     

Datatouille's avatar
Datatouille
Solution Sage
8 years ago

Hi Ana,

 

Try this measure:

 

Total Budget Final = IF( NOT (ISFILTERED ('Product'[Product]) ) , [Total Budget] ,BLANK() )

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks, Tristan !!

 

It works ok, :smileyhappy:

 

Best regards