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}
)
Hi Anonymous ,
It would be helpful to answer more specifically if you could share some sample data with expected output. Based on what you are trying for that, below would be ideal code:-
Site Mileage =
CALCULATE (
SUM ( TrakM8[Distance (mi)] ),
TrakM8[Start Date]
IN { "10th Street", "11th Street", "12th Street", "13th Street", "14th Street" }
)
Thanks,
Samarth
Hi,
Many thanks for your response.
I copied your DAX word for word and recieved no errors but when placing into into a table or card visual I recieve the below error.
Also how would I ammend the DAX to allow for text filters from two different columns?
Cheers,
Elliot
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?