Forum Discussion

R554's avatar
R554
Frequent Visitor
8 years ago

Countif with conditon

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 .   ...
Need Help
Show and Tell
R554's avatar
R554
Frequent Visitor
8 years ago

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

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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