topic Re: Through measure the multiple values are wrong in DAX Commands and Tips

Through measure the multiple values are wrong

asdf1608 — Fri, 12 May 2023 13:51:28 GMT

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.

aaa.pbix

Please work in this power BI. I am not able to figure it out

Thanks in advance

Re: Through measure the multiple values are wrong

Wilson_ — Sun, 14 May 2023 19:57:52 GMT

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?)

Re: Through measure the multiple values are wrong

asdf1608 — Mon, 15 May 2023 08:34:06 GMT

Wilson_ Thank you so much