Forum Discussion

Gpera's avatar
Gpera
Regular Visitor
2 years ago
Solved

Calculating percentage over date level

Hi, As you can see I have a table with these data: Share of Voice has been calculated as:  divide('Adspend - Monthly data'[Spend ('000 Euro)], 'Adspend - Monthly data'[Total Category Spend ...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    Gpera,

     

    Try these measures. Percentages need to be calculated in a measure, not a column in the table; this allows them to dynamically calculate in the filter context of the visual.

     

    Sum of Spend = SUM ( Spend[Spend] )
    Sum of Total Category Spend = SUM ( Spend[Total Category Spend] )
    Share of Voice = DIVIDE ( [Sum of Spend], [Sum of Total Category Spend] )

     

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

Gpera,

 

Try these measures. Percentages need to be calculated in a measure, not a column in the table; this allows them to dynamically calculate in the filter context of the visual.

 

Sum of Spend = SUM ( Spend[Spend] )
Sum of Total Category Spend = SUM ( Spend[Total Category Spend] )
Share of Voice = DIVIDE ( [Sum of Spend], [Sum of Total Category Spend] )