Forum Discussion
DISTINCTCOUNT with FILTERED MEASURE
Hi there, I am quite new to PowerBI and still struggling to understand the calculations performed behind the functions. Commited to learn thought! :) My struggle right now is the following. I...
Anonymous
try this alternative
Unique Customers, +50% Books (#) = COUNTROWS ( FILTER ( VALUES ( 'Sales'[CustomerID] ), [BookPurchases (%)] >= 0.5 ) )
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
try this alternative
Unique Customers, +50% Books (#) =
COUNTROWS (
FILTER ( VALUES ( 'Sales'[CustomerID] ), [BookPurchases (%)] >= 0.5 )
)
It does work! Thanks :)