Forum Discussion

mukagalvani's avatar
mukagalvani
Regular Visitor
7 years ago
Solved

Help with simple measure

Hey there!

 

I have a column called 'evaluation'. It contains 4 types of field: Bad, Regular, Good, Great.

 

Looks like this: 

 

 

I need to SUM only 'good' and 'great' lines in a measure in order to generate a graphic.

 

Tried to use SUM, SUMX and even COUNT, but don't know exactly how I can SUM different fields in a column.

 

 

Thanks!

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, mukagalvani

    After my research, you could try this formula like below:

    Measure = CALCULATE(COUNTA('Table'[Customer]),'Table'[evaluation]="Good"||'Table'[evaluation]="Great")+0

    Result:

    If not your case, please share some data sample and expected output. Do mask sensitive data before uploading.

     

     

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, mukagalvani

    After my research, you could try this formula like below:

    Measure = CALCULATE(COUNTA('Table'[Customer]),'Table'[evaluation]="Good"||'Table'[evaluation]="Great")+0

    Result:

    If not your case, please share some data sample and expected output. Do mask sensitive data before uploading.

     

     

    Best Regards,

    Lin