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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You could use IF or SWITCH to achieve this.

 

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

  • R554's avatar
    R554
    Frequent Visitor
    8 years ago

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

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