Forum Discussion
Fair Share Calculation
Sure - here is the model. TA and xAOC are the made data sources; the rest are mapping files.
My products are Total Departments (ie the total retailer), then Clients (ie manufacturers). The clients don't total up to the Total Departments; and Total Departments is a singular product pulled from our system. So, it will change as retailer and time period changes. But - I don't want it to change depending the product (row) displayed...
Hi JillHenninger ，
If I understand correctly, the Client column in your matrix is the column of the Representation table. So you need to modify the measure to
FairShare = CALCULATE([Market Share], Representation[Client] = "Total Departments")
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.