Forum Discussion
Summing a category from another table
So I am running into an issue with a sum of total calculation based on an identifier. For some reason when summing the total, Power Bi does not use the identifier to aggregate the sum.
In the above example, the total column is calculated based on the date but I want to calculate this based on the classification.
Above is my table diagram demonstrating the relationships between my datasets. Total and date only exist on the far right table while the classification only exists on the far left table. Do my relationships prevent me from doing this? Any help would would be appreciated.
Thanks
- Anonymous4 years ago
Anonymous this is becuase, you do not have relation between dim_channeladviso to fact_channeladvisor.
Find out if is there any column that you can map with these tables.
1 Reply
- AnonymousNot applicable
Anonymous this is becuase, you do not have relation between dim_channeladviso to fact_channeladvisor.
Find out if is there any column that you can map with these tables.