CODEWITHSUNDEEP
powerbipowerbi-desktop
Himanshu sharma
Himanshu sharma

Reputation: 7929

How can i get total of distinct value correct?

I am using powerbi to represent the distinct count of each browser .

and at the end I want total of all of them which is coming wrong.

enter image description here

See the total is coming wrong.

I am using this formula

Count of Unique PERSON_ID =
SUMX(DISTINCT('USAGE'[BROWSER]), DISTINCTCOUNT('USAGE'[PERSON_ID]))

What i am doing wrong ? New to Powerbi

Upvotes: 1

Views: 1857

Answers (1)

Himanshu sharma
Himanshu sharma

Reputation: 7929

You can do like this

  Count of Unique PERSON_ID = 
          SUMX(DISTINCT('USAGE'[BROWSER]),  
          CALCULATE(DISTINCTCOUNT('USAGE'[PERSON_ID])))

Upvotes: 1

Related Questions