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. ...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    hi, you can obtain with this: 

     

    TargetAll = CALCULATE(SUM(Table1[Target]),ALL(Table2[Date]))
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]))
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Vvelarde,

        It worked. Thank you very much:)

    • BhaveshPatel's avatar
      BhaveshPatel
      Super User
      9 years ago

      Anonymous

      You can check that  I have not selected slicer in the screenshot. once you select the slicer, it will cross filter the values of X and Y as expected by you.