Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
4 years ago

Merge customers

Hello,   We have the same customers that have accounts in the system.  We would like to make sure that Power Bi pulls a report based on the total of the same customer with multiple accounts.  Do we...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Oros  you need  a dimCustomer tbl for that-> create relationship with Fact->bring axis from dim->aggregate on fact

 

Customer Alpha Name Customer
a1 a
1a a