Forum Discussion

Sab's avatar
Sab
Icon for Helper V rankHelper 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's avatar
    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

Sab's avatar
Sab
Icon for Helper V rankHelper 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's avatar
Sab
Icon for Helper V rankHelper 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.