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
Anonymous's avatar
Anonymous
Not applicable
8 years ago
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'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.