Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The first argument to SUMMARIZE is a table. The amount is irrelevant (assuming the presence of a record in the fact table indicates a sale took place).
The Amount is showing as red error also.
I'm wondering is there a workaround code or something to fix this?
All the tables in my data model have correct relationships also.
Yes some kind of fact table is needed to identify whether a customer purchased the item in the time range (otherwise you don't have the information). Normally this would be some kind of sales table with keys to the customer dimension, date dimension and item dimension.
When I input the table that has the sales figure I get a red error.
What's the best way to fix this?
Apologies I'm new to Power BI so unsure of some things.
Try this:
Thanks for the response.
I haven't got a Sales table in my data. I have a table called 'Module Sales with Inventory' that has an amount field.
Do I need to put something else instead of sales?
I have included below sample data and the expected outcome also below here if that would help:
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |