Forum Discussion
Measurement Calculations using Data from Two Different Tables & Model View Connection?
Hi, I'm struggling to connect my data from two different tables for my measurement. Below I'll paste the measurement I created to try and calculate the rate "events" per unit delivered: ...
Ohhh, I understand.
You can try the following measure:
Events vs Amount =
VAR _Events= COUNTROWS(Events)
VAR _Amount=SUM(Amounts[Amount Delivered])
VAR _Events_vs_Amount=DIVIDE(_Events,_Amount)
RETURN
_Events_vs_Amount
Okay I was able to get that calculation to work, but whenever I go to filter by the supplier name it stops working. I think theres an issue with my model view connections.
I actually created a table with all of the Supplier Names with no duplicates and it still wants to create a Many:Many relationship