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.
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?
Solved! Go to Solution.
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.
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.
Your question is not clear. Share some data and show the expected result.
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.
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.
This exactly what I was looking for !!
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |