Have a question regarding using both power pivot and pivot table together

Summer Lane 21 Reputation points

Please see attached screenshot:
I have 1 regular table, power pivot data model, power pivot table
I suspect I wrote the wrong measures for what I wanted to achieve.

This is my measure: Current total$:=SUMX(DISTINCT(Table1[CURRENT]),SUM([Sales$]))
The pivot table shows the current total $ for Sarah is 400, however I thought my measure has put a filter on "current", that SARAH is not on the current list, so for Sarah, the sales should be 0.

How do I modify the measure or add one to get 0 for Sarah's current total?


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,988 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,347 questions
{count} votes

0 additional answers

Sort by: Most helpful