Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with differentiating individuals and associated conditions within the month

Hello All,   This is my first time posting so please bear with me! I'm having some issue with a calculation as more people are entering our datatset.   I have a graph that is calculating individ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 

    You cannot just allexcept like that in dax, try measures like the following.

     

    RunningSum  Category A=
    CALCULATE(
    SUM([value] ,
    FILTER(Allselected(table), table[Category]="A" &&
    table[LastDayOfMonth] <= MAX(table[LastDayOfMonth])
    ))

     

    RunningSum  Category B=
    CALCULATE(
    SUM(Category B ,
    FILTER(Allselected(table), table[Category]="B" &&
    table[LastDayOfMonth] <= MAX(table[LastDayOfMonth])
    ))

     

    However, without seeing the data, it is difficult to provide further detail. You can repost a sample pbix and replace sensitive data with random values.

     


    Paul Zheng _ Community Support Team

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello,

 

Thanks for taking the time to answer, unfortunately I'm not able to share the dataset which is a bit of a bummer. I've looked on the desktop forums and I'll certainly post my question there next time.

 

Unfortunately the distinct count doesn't quite work for the above, I've tried to assign the two calculations as variables but it's throwing a syntax error. I'll see what I can find on the forums!

 

Thanks again.