Forum Discussion

Mbryanton's avatar
Mbryanton
Regular Visitor
2 years ago
Solved

Help with a writing a DAX function based on conditions of another column

I am still very new to DAX, but I have a table where I need to create a DAX measure to add up the values from the Values column if the Origin Column equals 4 specific locations. And then another measure to add the values if the same origin column does not equal those first 4 locations. 

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Try this

    Measure(not included) =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] NOT(IN { Origin1, Origin2, Origin3, Origin4 })
)

     

    Mark this answer as solution, if works for you

6 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Mbryanton 

    I am sharing the idea of the DAX measure, please update 

     

    Measure(not included) =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] <> { Origin1, Origin2, Origin3, Origin4 }
)

     

     

     

    Measure(included) = =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] IN { Origin1, Origin2, Origin3, Origin4 }
)

     


    If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

     

    • Mbryanton's avatar
      Mbryanton
      Regular Visitor
      2 years ago
      Hi there! The second measure works! but I get an error when trying to apply the first one ( Measure - Not Included) that says " Couldn't load the data for this visual - A table of multiple values was supplied where a single value was expected?
      • PijushRoy's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Try this

        Measure(not included) =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] NOT(IN { Origin1, Origin2, Origin3, Origin4 })
)

         

        Mark this answer as solution, if works for you

    • Mbryanton's avatar
      Mbryanton
      Regular Visitor
      2 years ago

      Hi there! The second measure works! but I get an error when trying to apply the first one ( Measure - Not Included) that says " Couldn't load the data for this visual - A table of multiple values was supplied where a single value was expected?