Forum Discussion

Henneking's avatar
Henneking
Frequent Visitor
7 years ago
Solved

Conditional sum with active check box

Hi all,   The following is my problem. I am currently trying to create an intuitive backlog chart which can be filtered by using a checkbox slicer. I would like to have chart that shows me the back...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Henneking ,

     

    By my test, you could create a measure to implement the result. Since you didn’t post the measure of Backlog_kum, I create  a sample using the values of Planed and Issued. Then you can change the measure to filter  “Backlog_kum”.

     

    I create two measures to display the column of Planed and Issued instead of using calculated column. There are the relationships about two tables. And they are all many-to-one and inactive.

    Planed = CALCULATE(SUM(Data[Quantity{KG}]),USERELATIONSHIP('Date'[Dates],Data[Planned Issuing Date]))

    Issued = CALCULATE(SUM(Data[Quantity{KG}]),USERELATIONSHIP('Date'[Dates],Data[Acual issuing date]))

     

     

    Best Regards,

    Xue Ding

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Henneking ,

 

By my test, you could create a measure to implement the result. Since you didn’t post the measure of Backlog_kum, I create  a sample using the values of Planed and Issued. Then you can change the measure to filter  “Backlog_kum”.

 

I create two measures to display the column of Planed and Issued instead of using calculated column. There are the relationships about two tables. And they are all many-to-one and inactive.

Planed = CALCULATE(SUM(Data[Quantity{KG}]),USERELATIONSHIP('Date'[Dates],Data[Planned Issuing Date]))

Issued = CALCULATE(SUM(Data[Quantity{KG}]),USERELATIONSHIP('Date'[Dates],Data[Acual issuing date]))

 

 

Best Regards,

Xue Ding

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Henneking's avatar
Henneking
Frequent Visitor
7 years ago

Thanks man!! You are insane!