Display occurrence count using Card visual

[Anonymous]

Dear all
sorry to say that am stuck in task as below details

the case is have coulmn with faultsID, so i want to display count of faultIDs that repeated 50 times or more

lets say, if i have one ID repeated 50time or more then i have to display value one, and so on for other IDs.

thanx

[az38 · Accepted solution]

Hi @Anonymous 

try smth like

Measure = 
var _cnt = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[faultsID]) )
RETURN
IF(_cnt > 50, 1, 0)

[Anonymous]

HI
soory may be i am not make it clear

i have coulmn with faultIDs, 

if three IDs is repeated 50 time or more (Each one is repeated 50 times) then i have to display 3 in the card

thanx in advance for your support

[az38]

@Anonymous 

try to SUMX() function in measure and put this measure into a card visual

Measure = 
CALCULATE( SUMX(Table, IF(_cnt > 50, 1, 0)) )