Forum Discussion

arp's avatar
arp
Regular Visitor
7 years ago
Solved

Using distinct count in a measure

Hi all,   I'm relatively new to the world of Power BI so apologies if this is relatively obvious to some of you...   I have a list of ID numbers that are duplicated within a multi-year dataset. I...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    arpCould you please post the error message that you are getting. Here is the same in "Multi-row card" visual as well

     

themistoklis's avatar
themistoklis
Community Champion
7 years ago

How about creating separate measures for each year with both the actual and the % values. 

Measure= CALCULATE(DISTINCTCOUNT('Table'[Values]), 'Table'[year] = 2018)
arp's avatar
arp
Regular Visitor
7 years ago

Hi,

Thanks for the response.

 

This is exaclty what I've tried by I'm getting an error message when I try and use the measure in a visualisation...

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    arpCould you please post the error message that you are getting. Here is the same in "Multi-row card" visual as well

     

    • arp's avatar
      arp
      Regular Visitor
      7 years ago

      Thanks both,

       

      error message no longer displaying, probelm solved!

       

      Thank you very much for your help, much appreciated.