Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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") ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Is it possible for you share sample data with expected output or sample file after removing confidencial data??

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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
    510th Street
    1010th Street

     

    5410th Street
    6411th Street
    2412th Street

     

    • Samarth_18's avatar
      Samarth_18
      Community Champion
      4 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.