Forum Discussion

afaherty's avatar
afaherty
Icon for Helper V rankHelper V
4 years ago
Solved

PowerBI is counting the same value as 2 different values

Hello, This is a very complicated question, therefore I am trying to simplify it and I hope I don't confuse anyone further. I have a database of student evaluations.  Their professor has rated them...
  • afaherty's avatar
    afaherty
    4 years ago

    I found another post from someone who had the same problem a few years ago.  When they re-did the dashboard from scratch, the problem went away.  I just tried the same thing, and my problem has resolved as well.  

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

To follow a few replies here. To see if DAX has gone wild, you can go to TRANSFORM Data and highlight your column and first select clean and after repeat with "trim". Both options are under the TRANSFORM Tab. Choose FORMAT and the there is a drop down. These two functions(Clean & trim) take away spacing issues and also take away any non printable characters. I've rad it's best practice to do this before loading data.

 

If you do this and you still have an issue, then maybe DAX has an issue? I hope this helps!