Forum Discussion

Arnault_'s avatar
Arnault_
Resolver III
4 years ago
Solved

Countx within context transition

Hi All,   I am struggling with a context transition problem. I have preapared a simple data model to illustrate it. I have: - 1 transaction table with values that I need to aggregate (in this ta...
Need Help
  • Arnault_'s avatar
    Arnault_
    4 years ago

    Hi lbendlin , you are right. I have found the answer myself and updated the pbix. I just didn't had time to update the post here. 😉

    Now I am trying to develop the logic further and get the cumulated value (using ALLSELECTED). I have not succeeded yet, but I will post a complete answer if I mange to get the expected result. If you have any idea on how to achieve this it will be welcome.

lbendlin's avatar
lbendlin
Super User
4 years ago

Your pbix already has the anwer?  

"Count value (w/o dupliactes & based on date_2) v2" modifies the data model to use the other relationship.
Arnault_'s avatar
Arnault_
Resolver III
4 years ago

Hi lbendlin , you are right. I have found the answer myself and updated the pbix. I just didn't had time to update the post here. 😉

Now I am trying to develop the logic further and get the cumulated value (using ALLSELECTED). I have not succeeded yet, but I will post a complete answer if I mange to get the expected result. If you have any idea on how to achieve this it will be welcome.