I´m having the following problem; i need to create a matrix visualization where my first column are Clients and those clients have license plates associated to them (See image attached). So every license plate have a rate (How much we charge one client for that vehicle), and sometimes that rate is the same for different vehicles. Basically the problem is having the same price for different ID's.
In the attached image you can see that the total it´s not right, it´s not considering those repeated rates and gives me a total that´s a lot less than it should be.
Any suggestions for a DAX formula or measure? I´ve tried some stuff but don´t seem to work out. Thanks a lot in advance.