Forum Discussion

Helper V

6 years ago

Solved

Measure not working when using in table with other columns

Hello, I have a column: SCORE with values 1, 2, ..., 10. Then I have 3 measures: Detractors = CALCULATE(COUNT('Responses Database'[SCORE]),'Responses Database'[SCORE]<7) Promoters = CALCU...

Need Help

Sab
6 years ago
The score column is the one that has values that create the measure.

So the column date is in relationship with Date Table, no problem with Quarters, months etc.

But the problem is when I put in the table visual along with for example Company column.

I tried your solution, but the values get too low

v-eachen-msft

Community Support

6 years ago

Hi Sab ,

Would you like to provide some sample data? The information you give is limited, I can't get the context of the table.

And you can try this measure:

NPS =
 ( [Promoters] - [Detractors] )
    / CALCULATE (
        COUNTROWS ( 'Responses Database' ),
        ALLEXCEPT (
            'Responses Database',
            'Responses Database'[Campany],
            'Responses Database'[Quarter]
        )
    ) * 100

Sab
Helper V
6 years ago
- Sab
  Helper V
  6 years ago
  The score column is the one that has values that create the measure.
  
  So the column date is in relationship with Date Table, no problem with Quarters, months etc.
  
  But the problem is when I put in the table visual along with for example Company column.
  
  I tried your solution, but the values get too low
  - Sab
    Helper V
    6 years ago
    There was no problem in measures, just the dummy data created that illusion...
    
    Thanks all who took time to look at this.