Forum Discussion
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 measur...
hi, mukagalvani
After my research, you could try this formula like below:
Measure = CALCULATE(COUNTA('Table'[Customer]),'Table'[evaluation]="Good"||'Table'[evaluation]="Great")+0Result:
If not your case, please share some data sample and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
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