Good afternoon,
I have generated a table in Power Pivot that calculates the book name in the table below using a formulas as follows
I am struggling to get the "Author 1" part below to add up the Book 1 - 5, even if I duplicate the filter option above with each filter.
What is the best way to do this?
thanks in advance
I have generated a table in Power Pivot that calculates the book name in the table below using a formulas as follows
Code:
if(Listings[Title]="S.D. 3 Questions",CALCULATE(COUNTROWS(Main Info), FILTER(Main Info,Main Info[Book Title]=Listings[Book Title]),FILTER(Main Info,Type=Listings[Type]),
FILTER(Main Info,Main Info[Author]="Author")blank())))I am struggling to get the "Author 1" part below to add up the Book 1 - 5, even if I duplicate the filter option above with each filter.
What is the best way to do this?
| Author 1 | |
| Book 1 | 4971 |
| Book 2 | 1263 |
| Book 3 | 645 |
| Book 4 | 63 |
| Book 5 |
thanks in advance
