Forum Discussion
SUM Filter Text
Hi All, I am trying to create a measure to sum one column then filter that sum based upon text values in another column. (The text filter will have to be based on a "or" function, not "and") ...
Yes you can add like below
Site Mileage = CALCULATE ( SUM ( TrakM8[Distance (mi)] ), TrakM8[Start Date] IN { "10th Street", "11th Street", "12th Street", "13th Street", "14th Street" },
TrackM8[somecolumn] IN {somevalue1,somevalue2,somevalueN}
)
This filter needs to be kept in the DAX as I will be creating additonal DAX using this measure.
The below DAX works fine but is there any way I can add another column text filter to it?
Site Mileage =
CALCULATE (
SUM ( TrakM8[Distance (mi)] ),
TrakM8[Start Date]
IN { "10th Street", "11th Street", "12th Street", "13th Street", "14th Street" }
Yes you can add like below
Site Mileage =
CALCULATE (
SUM ( TrakM8[Distance (mi)] ),
TrakM8[Start Date]
IN { "10th Street", "11th Street", "12th Street", "13th Street", "14th Street" },
TrackM8[somecolumn] IN {somevalue1,somevalue2,somevalueN}
)