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}
)
I want to filter based on text for two columns.
For example,
SUM of miles
Filter by column 1 "text"
Filter by column 2 "text"
Hope that makes sense.
if column 1 and column 2 belongs to same table you can directly use that as visual level filter and you select the value according to your need and it will filter the data.
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}
)