Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Divide With a Filter

Quick question.. I'd assume it will be a simple answer. Say I have a table with monthly sales and a table with monthly sales with a visual level filter of some sort.. How could I create a third table...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Figured it out.. it was simple as I expected. Still getting comfortable with CALCULATE and FILTER expressions..

     

    PercentA = divide(CALCULATE(sum(Sheet1[Sales]),Sheet1[Item Type]="A"),SUM(Sheet1[Sales]))

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Figured it out.. it was simple as I expected. Still getting comfortable with CALCULATE and FILTER expressions..

 

PercentA = divide(CALCULATE(sum(Sheet1[Sales]),Sheet1[Item Type]="A"),SUM(Sheet1[Sales]))

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

Anonymous

 

If you have got your problem answered, you could mark the right answer as solution to close this thread. :smileyhappy:

 

Best Regards,

Herbert