INVENTORY MANGEMENT

[FJO]

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. 

 

[Anonymous]

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]

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