Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?)
Proud to be a Super User! | |
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?)
Proud to be a Super User! | |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |