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.
I am converting the tableau dashboard to power BI. I find this very difficult.
There is a field "Discount" which gets divided by parameter "Parameter 1".
This converted value is multiplied by "Row ID" field. This is the basic concept. This is easily possible in Tableau.
The result is this
But in Power BI it is difficult.
I have created the parameter "Unit Conversion" and used that field to get it divided by "Discount".
This is done in measure since in column multiple values is not possible.
Now to get this multiplied by Row ID
The result is totally wrong.
I am not sure of why through measure the simple multiplication is wrong.
How do I get this correct.
Help in this is needed.
Please work in this power BI. I am not able to figure it out
Thanks in advance
Solved! Go to Solution.
Hello asdf1608,
This is also easily done in Power BI! 🙂
Try this for your measure 2 instead:
Measure 2 =
SUMX (
Sheet1,
[Conversion] * Sheet1[Row ID]
)
The reason your original Measure 2 wasn't working is because you wanted the calculation to go row by row, but Power BI doesn't know that unless you use an iterator function (like SUMX); instead of going row by row, multiplying the row ID and conversion together then adding it all up at the end, it was adding up all the row IDs, adding up all the discounts, then multiplying the two numbers together (ie: 1,583.99 * 51963915).
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Hello asdf1608,
This is also easily done in Power BI! 🙂
Try this for your measure 2 instead:
Measure 2 =
SUMX (
Sheet1,
[Conversion] * Sheet1[Row ID]
)
The reason your original Measure 2 wasn't working is because you wanted the calculation to go row by row, but Power BI doesn't know that unless you use an iterator function (like SUMX); instead of going row by row, multiplying the row ID and conversion together then adding it all up at the end, it was adding up all the row IDs, adding up all the discounts, then multiplying the two numbers together (ie: 1,583.99 * 51963915).
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |