Countif with conditon

Question

Hi Everyone,&nbsp;I am quite new to Power BI. I have a scenario as below-&nbsp;I have table (Customer Table), based on the count of column against each customer from the table i have given scores .&nbsp;Ex: Customer 1 has 2 errors or appeared twice in the table then based on the count of number of errors i have to give scores.&nbsp;Errors Points1 202 103 and more 0&nbsp;&nbsp;How can we achieve this task.&nbsp;Thanks in advance!

greg_deckler · Answer

You could use IF or SWITCH to achieve this.&nbsp;Basically, IF([Count]&lt;2,20,IF([Count]&lt;3,10,0))

r554 · Answer

Hi Greg,&nbsp;Sorry if i was not clear in the first post. I would need the output something as below-&nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Errors&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PointsCustomer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;I have to present this table under Visualization. Also, to add to the above i have some other metrics from different tables where i have to apply if conditions based on the customer and the metric count for each customer and get the scores&nbsp;You can think this like a various tables with unique Customers list in one table and all i have to do is get each metric (count) from different tables to one table and present it as graph/table...

anonymous · Answer

R554&nbsp;wrote:
&nbsp;
You can think this like a various tables with unique Customers list in one table and all i have to do is get each metric (count) from different tables to one table and present it as graph/table...

R554,Do you also need to calculate error counts for each customer based on different tables? If so, please&nbsp; share dummy data of these tables and post relationships among them.Regards,Lydia

r554 · Answer

Anonymous&nbsp;Please find the dummy data in the below mentioned link-&nbsp;https://drive.google.com/file/d/1GzQ8qW1Fkp9TUZRy-Ffc-ffpBinBD3mG/view?usp=sharing&nbsp;Relationships - I want to create a list of suppliers in a separate table (Unique Supplier List) and link&nbsp;this table with all the other tables as per attached file.&nbsp;Relationship is&nbsp;supplier for all tables.&nbsp;The catch here is the data tables have data broken down by month and my calcualtion should be number of errors made by a particular supplier for that specific month.&nbsp;I want to create a visualization where end user have to select Month (Reporting Date in all tables) and list of suppliers with their Scores from different tables should populate.&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

R554,What logic do you&nbsp; use to calculate errors for these suppliers? Please help to post expected result in table format based on your dummy data.Regards,Lydia

Forum Discussion

Countif with conditon

6 Replies

Related content

COnditonal Column

Complex Conditonal Formatting

Index Countif

Countifs

Conditonal Statement