Forum Discussion
Solved
Calculating a % between two numbers in two queries
I hope someone can help. I have tried quick measure and it crashes everytime. So I have two queries runniing from SQL, linked a relationship between "Customer Name" single slicer searches bot...
I don''t recommend joining your fact tables to each other (i.e. joining Query1 to Query2), a star schema should be used. I would also still recommend creating the individual explicit measures, but if you don't do that you could do Percentage = DIVIDE(SUM('Query1'[Items]),SUM('Query2'[Remakes]))
audreygerredYou have saved me some grey hairs, I will read through your posts tonight.
A great thank you for taking the time to help , really appriciated !
Happy to help! Good luck on your Power BI journey!!!