Excel 365 Pro Plus with Power Pivot and Power Query.
With PQ Append().
https://www.mediafire.com/file/w3wcewu3lw1w7h5/01_01_23.xlsx/file
https://www.mediafire.com/file/texgrssre7vgnha/01_01_23.pdf/file
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.
44,052 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,939 questions
Accepted answer
-
Herbert Seidenberg 1,191 Reputation points
2023-01-01T15:23:42.61+00:00