Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with DAX Language

Hello,  I'm extremely new to this program, and don't fully understand how the language works.   I managed to create a table to display the data I need (see picture) but I really need to create it ...
Commands and Tips
  • BeaBF's avatar
    BeaBF
    4 years ago

    Anonymous 

    Measure = CALCULATE(SUM([#Negative]), [State] = "Alabama")

     

    Try this!

    B.

BeaBF's avatar
BeaBF
Super User
4 years ago

Anonymous  can you send the table on which create the mesure? And explain to me what measures would you need?

B.

  • ERD's avatar
    ERD
    Community Champion
    4 years ago

    Anonymous , where will use use those measures? what is the final result you want to achieve?

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      BeaBF  I'm sorry, I have no idea how to send a table. I need a measure that is basically 

      AlabamaNegSamples= [#Neg] IF(state="alabama") but i don't know how to say that in the DAX language.

       

      ERD I'm going to be using these measures for pie charts and/or bar graphs, comparing positive and negative samples from individual states.