Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 no. 1. In PowerBi it shows as the values True or false instead of 0 and 1.
The tablename is NSP_Tickets and column name is u_misroutereport
Thanks!!
Hi @Anonymous ,
Try this one, please.
Counter = CALCULATE ( COUNT ( NSP_Tickets[u_misroutereport] ), NSP_Tickets[u_misroutereport] = TRUE () )
Best Regards,
Hi @Anonymous ,
Could you please mark the proper answers as solutions?
Best Regards,
create a measure to make condistional count as follows
Counter = CALCULATE(COUNT(NSP_Tickets[u_misroutereport]),NSP_Tickets[u_misroutereport] = 1)
this gives me the following error:
dxScript (Model) (4, 78) Calculation error in measure 'NSP_Tickets' [Counter]: True / False values cannot be compared with integer values in DAX comparisons. Consider using the VALUE or FORMAT function and converting one of the values.
Ok, seems the values are not integers, please state the type of this column (text, boolean, ..etc)
You can modify the formula to deal with the column type as follows
Counter = CALCULATE(COUNT(NSP_Tickets[u_misroutereport]),NSP_Tickets[u_misroutereport] = "1")
or
Counter = CALCULATE(COUNT(NSP_Tickets[u_misroutereport]),VALUE(NSP_Tickets[u_misroutereport]) = 1)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |