Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with Count

Hi Everyone, I am new to Power BI and I have a count problem. In the table below, I am trying to create an analysis of how the delivery days of the following products have changed from Jan - May. Th...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

  1.  Unpivot month columns in Power Query (see figure).
  2. Use a table visual and the following measure:
Count Delivery Days = SUMX('Table','Table'[Delivery Days] * 'Table'[Value])

 With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi FrankAT,

     

    Thanks for the message. However, I am not trying to count the delivery days. I want to count the product that have more than one delivery days value. For instance, Product A has 2 values in delivery days (i.e. 60 and 90), while Product B has only 1 value in delivery days (i.e. 60).

     

    FrankAT 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Update: We can ignore the months columns as I can see that it is causing some comfusion.

      mahoneypat FrankAT 

      • FrankAT's avatar
        FrankAT
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Hi Anonymous 

        is this what you are looking for:

         

        With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
        FrankAT (Proud to be a Datanaut)