I have computed a measure names "Saldo".
In a table there is a column named "Factor" which has the value of "1" or "-1".
I want to compute the measure "Saldo" with the column "Factor".
Apparently this doesn't work beacause I can not use a column value in my measure.
How can I make the computating anyway ?
Is there a way to store the "factor" in a variable and do the computation?
Go to Solution.
I am not sure how your datamodel looks like or how your desired outcome looks like, but I tried to create a sample pbix file like below.
One of ways to achieve this is to use iterator DAX function, like SUMX (or any other functions that is related to iteration).
Please check the below picture and the attached pbix file.
I hope the below sample can provide some ideas on how to create a solution for your datamodel.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
Your question is not clear. Share some data and show the expected result.
This exactly what I was looking for !!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.