How to get row count as a scalar value in a measure

[ravimerugu]

I have a visual that shows percentage of shoppers who rated individual brands above a certain rating number. To caluclate the percentage, I need to find the total number of shoppers at the brand level as a category. I am using the following query. It does give me the required total value on its own, but is drills down to each brand when I put it in the table (shown below). From the table shown, the brands, Maserati, Alfa Romeo, and Fisker show incorrect total value. It should the 228333. This is messing up my percentage calculations. What do I have to do to get a scalar value?

Total Shopper Count =
CALCULATE (
DISTINCTCOUNT ( 'Rating Table'[Shopper Id] ),
ALL ( 'Rating Table'[Rating Number] ),
'Rating Table'[Marketing Insight Attribute Name] = "Brand"
)

[Phil_Seamark · Accepted solution]

HI @ravimerugu

I think I see what you are trying to do.

Try this variation and see if this helps

Total Shopper Count = 
CALCULATE (
DISTINCTCOUNT ( 'Rating Table'[Shopper Id] ),
ALLEXCEPT( 'Rating Table','Rating Table'[Marketing Insight Attribute Name] ),
'Rating Table'[Marketing Insight Attribute Name] = "Brand"
)

[ravimerugu]

Thanks so much, Phil! That did the trick!!