Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Display occurrence count using Card visual

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

Hi Anonymous

try smth like

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

3 Replies

az38
Community Champion
6 years ago
Hi Anonymous

try smth like

Measure = var _cnt = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[faultsID]) ) RETURN IF(_cnt > 50, 1, 0)
- Anonymous
  Not applicable
  6 years ago
  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
    Community Champion
    6 years ago
    Anonymous
    
    try to SUMX() function in measure and put this measure into a card visual
    
    Measure = CALCULATE( SUMX(Table, IF(_cnt > 50, 1, 0)) )

Related content