Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    4 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

  • Anonymous's avatar
    Anonymous
    Not 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.