Forum Discussion
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...
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]))
I dont know for sure if this will help you, but there good examples of the use of "divide" with filters in this thread.
http://community.powerbi.com/t5/Desktop/Calculation-between-columns-on-a-table/m-p/73322