Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

count rows

Dear Friends i have table with thousands of rows as shown:  i need to count the number of "MR Number" wherer MR number contains only Status = "Initial", for example in above MR 1322398 & 1321...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a new measure like

     


    countx(filter(summarize(Table, Table[MR Number], "_cnt", count(Table[MR Number]), "_init", countx(filter(Table, Table[Status] = "Initial"),Table[MR Number])), [_cnt] =[_init]),[MR Number])

smpa01's avatar
smpa01
Community Champion
4 years ago

Anonymous 

Measure =
CALCULATE (
    COUNT ( tbl[Status] ),
    FILTER ( VALUES ( tbl[Status] ), tbl[Status] = "INITIAL" )
)