Forum Discussion

dkoek's avatar
dkoek
New Member
3 years ago
Solved

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". ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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.

 

 

dkoek's avatar
dkoek
New Member
3 years ago

This exactly what I was looking for !!