Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try smth like

    Measure = 
var _cnt = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[faultsID]) )
RETURN
IF(_cnt > 50, 1, 0)
az38's avatar
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's avatar
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's avatar
    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)) )