Forum Discussion

Kavya123's avatar
Kavya123
Icon for Helper III rankHelper III
7 years ago
Solved

Group By in DAX Measure

Hi Everyone,   I need to create a measure and do group by based on the Company name. For the below expression I need to get the values based on the aggregation of Company name. Please help me on th...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Kavya123 

    If you use your formula in a measure, then you could only add "company name" and this measure in a table or matrix visual.

    Measure = CALCULATE(sum( Sheet2[answertest]) , FILTER(Sheet2, CONCATENATE(Sheet2[Answer Text], Sheet2[Answer Text])="YesYes" ))

    Or if you want to show all columns and measures together in a table visual, you could create another measure

    Measure 2 = CALCULATE([Measure],ALLEXCEPT(Sheet2,Sheet2[company name]))

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

If you drag Company Name and your measure onto a visual the Group By will happen automatically. However your measure looks overly complicated. Have you tried the following pattern?

 

CALCULATE(sum( PROFILERTABLENEWSUBMITTED[answertest])
    , PROFILERTABLENEWSUBMITTED[Answer Text] = "Yes"
    , PROFILERTABLENEWSUBMITTED[Answer Text])="Yes"
)

  • Kavya123's avatar
    Kavya123
    Icon for Helper III rankHelper III
    7 years ago

    Hi,

     

    Thanks for the reply. I have tried that but it is not working.

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      7 years ago

      We can't really help much based on "it's not working".

       

      Can you maybe paste in 5-10 example rows of data and then show us an example of the result you would expect the calculation to produce from that sample data?