Forum Discussion

MikeSwe's avatar
MikeSwe
Regular Visitor
4 years ago
Solved

Multiplying distinct count with related table

Hi,   I am new to PowerBI and have been trying to solve the below. However after searching various forums without luck I thought to ask if someone could help with the below.   We have a table (ma...
Need Help
  • MikeSwe's avatar
    MikeSwe
    4 years ago

    I tried that but it did not work as the top row should give value 200.

    However we solved it by adding a calculated column to the main table with the cost value  and price added per row. The muliplication still did not work at first, due to one data being aggregated and the other were not. However using MAX did the trick and the data is presented correctly.

    Thanks!

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi MikeSwe ,

 

If you have created the following relationship, then I think you can try the measure.

 

Measure = [Nbr. Unique Site Category] * SUM(cost[Price]) * SUM(cost[CostValue])

 

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.

 

 

MikeSwe's avatar
MikeSwe
Regular Visitor
4 years ago

I tried that but it did not work as the top row should give value 200.

However we solved it by adding a calculated column to the main table with the cost value  and price added per row. The muliplication still did not work at first, due to one data being aggregated and the other were not. However using MAX did the trick and the data is presented correctly.

Thanks!