Countif with conditon

[R554]

Hi Everyone,

I am quite new to Power BI. I have a scenario as below-

I have table (Customer Table), based on the count of column against each customer from the table i have given scores .

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.

Errors Points

1 20

2 10

3 and more 0

How can we achieve this task.

Thanks in advance!

[Greg_Deckler]

You could use IF or SWITCH to achieve this.

Basically, IF([Count]<2,20,IF([Count]<3,10,0))

[R554]

Hi Greg,

Sorry if i was not clear in the first post. I would need the output something as below-

Name                 Errors              Points

Customer 1           1                      10

Customer 2           3                       0

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

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...

[v-yuezhe-msft]

---

@R554 wrote:

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  share dummy data of these tables and post relationships among them.

Regards,
Lydia

[R554]

@v-yuezhe-msft Please find the dummy data in the below mentioned link-

https://drive.google.com/file/d/1GzQ8qW1Fkp9TUZRy-Ffc-ffpBinBD3mG/view?usp=sharing

Relationships - I want to create a list of suppliers in a separate table (Unique Supplier List) and link this table with all the other tables as per attached file.

Relationship is supplier for all tables.

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.

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.

[v-yuezhe-msft]

@R554,

What logic do you  use to calculate errors for these suppliers? Please help to post expected result in table format based on your dummy data.

Regards,
Lydia

[R554]

@v-yuezhe-msft

Please find the below link for the logic

https://drive.google.com/open?id=1u8_F5y7zv8JqTfWzxplMaav7uZStdnVJ

Thanks