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 backlog development and then enables me to select the different hauliers to see which the backlog development for every haulier. 

 

Basically what I've done so far is creating a seperate Date table and matching the quantities regarding the planned issuing date and actual issuing date to the relating date. I needed the seperate date table to have a independend x achsis for charts. But then the info about the haulier is gone and I cannot use the slicer any more.

 

I hope this amazing community can help me. You find everything what ive used below. Thank you so much for your help in advance.


Regards,

Henneking

Additional column examplechartsdata

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.

2 Replies

  • 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.