Forum Discussion

FJO's avatar
FJO
Helper I
4 years ago

INVENTORY MANGEMENT

Dear fellow PBIX users

FJO - AKA novice in training here!

I really need some help with something that is holding me back that I cannot figure out. 

Below is thre table relationships. 

In the report section I have set my data up in a matrix visual, based on the SR DAily Stores Issues.

What I am trying to do is add a new column or measure which will allow me to count non-blanks in the month as 1. So if there wwas a pick result every month the count would be 12. The counta and count x function gives me the same result, which is adding the total quantities of per month. But that isn't what I am trying to achieve. This is really a key missing link for me to move forward with my project and assign ABC ranking. 

I cant figure out why its counting (summing) the values per column. 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi FJO ,

     

    You create a Binhits column of counts, and then count that column again in the matrix. Maybe it's better to create a measure here than to create a calculated column.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • FJO's avatar
      FJO
      Helper I
      4 years ago

      Hi 

      My gosh I am so sorry I have taken so long to reply. 

      After doing alot of testing, I still can't nail it. 

      I am thinking that creating a separate table will be the best solution in order to use to for ABC ranking analysis later on. 

      But I do not know how to create a table in Power BI of this type. I can't figure out the DAX code for it