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]))
Ill try and understand that .
Can i not do a measure
Percentage = DIVIDE('Query1' Items - Query2 Remake Items ?
How would i write that ?
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]))