Measure not working when using in table with other columns

[Sab]

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 = CALCULATE(COUNT('Responses Database'[SCORE]),'Responses Database'[SCORE]>8)

NPS = ([Promoters]-[Detractors])/[All Rows]*100

The calculation is OK and I can use the measure as Card or when I use it in table with Quarters from DateTable,

but when I use it in table with other columns from same table where SCORE column is, it doesn't work:

Please advise.

Thanks

Sab

[v-eachen-msft]

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]

[Sab · Accepted solution]

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]

There was no problem in measures, just the dummy data created that illusion...

Thanks all who took time to look at this.

[Aron_Moore]

Keep in mind tables will apply a "filter" context to your measure unless you explicitly tell it not to with a function like ALL().

[Sab]

Can you please be more specific?

thanks