Forum Discussion

gvg's avatar
gvg
Post Prodigy
8 years ago
Solved

Using FILTER on two tables

Hi experts,   I have a Dates table that is related to Sales table. I also have a slicer for Dates. I need to filter on columns from different tables in my CALCULATE. Something like this (just the F...
Show and Tell
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    gvg

     

    If you want to filter all dates which the sales is more than 100, you should build a measure for sales amount. Then use this measure as conditon in your FILTER() function.

     

    SalesAmount = SUM(Sales[Amount])

     

     

    FILTER ( ALL ( Date[Date] ),
               [SalesAmount]>100
)

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

gvg

 

If you want to filter all dates which the sales is more than 100, you should build a measure for sales amount. Then use this measure as conditon in your FILTER() function.

 

SalesAmount = SUM(Sales[Amount])

 

 

FILTER ( ALL ( Date[Date] ),
               [SalesAmount]>100
)

Regards,

 

  • gvg's avatar
    gvg
    Post Prodigy
    8 years ago

    Thanks v-sihou-msft !