Forum Discussion
SUM Filter Text
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}
)
Is it possible for you share sample data with expected output or sample file after removing confidencial data??
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 |
Seems "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?
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.