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}
)
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.
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}
)