Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I am trying to create a table using
table shipments =
SUMMARIZECOLUMNS(
dDate[Year],
dDate[Month],
"shipments Saved",
[Shipments Saved_corrected TEST])
I need to know if I can do this, if yes than how.
And should I be using SUMMARIZE function instead of
Solved! Go to Solution.
Hi,
It works well here:
Please check the filter field [Year] comes from new summarize table but not from original table.
If choosing [Year] from original table to filter, it caused the same issue as you like below:
If you still want to use this [Year] from original table to filter the new summarize table visual, you can create a relationship between them.
See my attached pbix file.
Best Regards,
Giotto
Hi,
It works well here:
Please check the filter field [Year] comes from new summarize table but not from original table.
If choosing [Year] from original table to filter, it caused the same issue as you like below:
If you still want to use this [Year] from original table to filter the new summarize table visual, you can create a relationship between them.
See my attached pbix file.
Best Regards,
Giotto
I am not able to view your file, it is asking for a Power BI update, but its up to date
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |