Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date Filter

Hi All, 

I have two tables like below:

I created a relationship between two tables using ProductID.

Then I created the following table and added a date slicer. My output is shown below. (Here, nov 2 is selected)

Here, for category X, product C target is not taken and for category Y, product E target is not taken.

But I want my output as below:

Is there a way to get the above output?

Thank You.

 

 

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    hi, you can obtain with this: 

     

    TargetAll = CALCULATE(SUM(Table1[Target]),ALL(Table2[Date]))

5 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    You can achieve the output by creating a new calculated column in your table 1 using below syntax.

     

    Quantity = SUMX(RELATEDTABLE(Table2),Table2[Qty])

     

    and the expected output is shown in the screenshot.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi BhaveshPatel

      Thank you for your reply.

      But this is not what I want. When I select nov 2 in date slicer, I want to show the Qty for nov 2 only. In your output, the Qty for category X is 83. But I want to display 43 when I select nov 2 in date slicer. Please see below:

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        Anonymous

         

        hi, you can obtain with this: 

         

        TargetAll = CALCULATE(SUM(Table1[Target]),ALL(Table2[Date]))