Forum Discussion

cgpahnk's avatar
cgpahnk
Frequent Visitor
2 years ago

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:   ...
Need Help
gadielsolis's avatar
gadielsolis
Resolver III
2 years ago

Sorry,

 

I'm not getting what you need, if you divide events per supplier by amount delivered this would give you a really low number

 

 

If you can put this in excel and show me the desired output I will be more than happy to help.

cgpahnk's avatar
cgpahnk
Frequent Visitor
2 years ago

Yes, my bad I should have clarified! The numbers should be low very low, and PowerBI will show these numbers with scientific notation, but with my calculation it showed all suppliers as having the same percentage.

  • gadielsolis's avatar
    gadielsolis
    Resolver III
    2 years ago

    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

     

    • cgpahnk's avatar
      cgpahnk
      Frequent Visitor
      2 years ago

      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