Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Eliminate Duplicates

I'm pulling data from an SP list. The list is made up of qualifications and certifications (1989 - 2020). Some of the qualifications repeat, as the employee needs to requalify periodically (1 per yr,...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Please share your measure expression (or your selected aggregations in the visuals).  The visuals you've shown don't seem to have a Date axis/component.  I suspect you just need to use distinct count or DISTINCT() or VALUES() in your measures.

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I'm new to PowerBI and I'm not very familiar with many of the technical terms. I'm making it up as I go along. I hope this is what you requested.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I'm not measuring anything by date in PowerBI.

     

    Its just a display counts performed in Power Apps or Sharepoint.