Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to divide two columns from two different tables and use a common filter in a third table.
The common column or filter is the Store Name.
The two data columns which I would like to use for the calculation are Sold ending 26th August[Quantity Sold] and Dispatched[Quantity Dispatched].
I would like to divide the sum of Sold ending 26th August[Quantity Sold](B) for a Stores[Store Name](C) by the sum of Dispatched[Quantity Dispatched](A)
I have tried using Related() and RelatedTable() and a few other options but I am stuck.
Dispatched table where example A data is found:
Sold ending 26th August Table where B sample data is found
Stores table - where C sample data is found - I want to use this to filter the other 2 tables
This is essentially how I want this report to work- Divide the first column by the second and another column stores the result.
How the relationships are currently set up
Tables and the columns used
Also, let me know if any more information is needed as I am new to these forums and rather new to PowerBI.
Any help would be greatly appreciated.
Solved! Go to Solution.
Sample data in a form that can be copied and pasted is always helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, I'm thinking something along the lines of:
Measure = DIVIDE(SUMX(RELATEDTABLE('Sold ending 26th August'),[Quantity]),SUMX(RELATEDTABLE('Dispatched'),[Quantity Dispatched]))
Sample data in a form that can be copied and pasted is always helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, I'm thinking something along the lines of:
Measure = DIVIDE(SUMX(RELATEDTABLE('Sold ending 26th August'),[Quantity]),SUMX(RELATEDTABLE('Dispatched'),[Quantity Dispatched]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |