Forum Discussion
Measurement Calculations using Data from Two Different Tables & Model View Connection?
Please try the following DAX:
Worth to mentioning, I did not change the relationship therefore still using many to many relationship.
I'm trying to get a percentage though, so basically
Events per Supplier/Amount per Supplier
For example, if I took the amount of events I had (15) and divided it the total amount delivered*100 I'd get a percentage, what I want to figure out is how to display this percentage for each unique supplier.
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.
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.
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