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}
)
My bad, I have just noticed an stupid area in my DAX.
How can I add another text filter for another column?
Sample data below.
| Distance (mi) | Start Date |
| 5 | 10th Street |
| 10 | 10th Street
|
| 54 | 10th Street |
| 64 | 11th Street |
| 24 | 12th Street |
Samarth_18
Community Champion
Community ChampionSeems "start date" column contains text but it is datatype marked as date. If you convert that column as text then you will not get that error.
Could you please elaborate below requirement:-
How can I add another text filter for another column?