Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count rows with specific value

I have a table in a SQL database that contains 3 diffrent "values": Null, 0 and 1                                 I need to get the nu,ber of rows back where it only counts the...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Try this one, please. 

 

Counter =
CALCULATE (
    COUNT ( NSP_Tickets[u_misroutereport] ),
    NSP_Tickets[u_misroutereport] = TRUE ()
)

 

 

Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,