Forum Discussion
Measure computed agianst table column
Hello,
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?
Hi,
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.
3 Replies
Hi,
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.
This exactly what I was looking for !!
Your question is not clear. Share some data and show the expected result.
