Forum Discussion
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...
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])
HI Anonymous ,
You can simply create a measure:
newCacl =
CALCULATE (
DISTINCTCOUNT ( yourTablname[MR Number] ),
yourTablname[Status] = "INITIAL"
)
In the above DAX just replace with your table name and column names.
Thanks,
Pragati
