Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a table with inventory count. I want to count how many stores are completed and how many are not completed for each category, but the issue I stuck on is, if store is not complete the count for that category it will not show up on my database. I still want to count them as not completed. Can anybody please help me to get it? Please see sample data for more explanation.
Thank you so much
Hi @Anonymous ,
Create Two Measures .
Completed Inv Count = CALCUALTE(COUNT(YourColName),FILTER(YOUR TABLE NAME,Count Sheet Status = "Completed"))
Not Completed Inv Count = CALCUALTE(COUNT(YourColName),FILTER(YOUR TABLE NAME,Count Sheet Status != "Completed"))
First Mesure will give you completed count send will give you not completed count then drag your category column you will get required out put
Hope thsi will help you plesae revert back if you have any issue
I really appreciate you taking time to help me, unfotunatley this is not going to work. even I tried it out, please see bleow picture.
Let me tell you why that is, in above picture 101 Orem is missing accessory count. They never did the accessory count on that week. So, it is not going to show up my database. It’s only going to show my database if they completed or committed. If you look at my data in count sheet status column only have two values completed or committed. That is why I got stuck. Usually each store must have 3 counts ( 3 category mean 3 counts) for each week. i hope this make sense to you. Any other idea?
Thank you so much
Hi ,
Sorry i dint get your question
Please clarify two things,
1) You mentioned that for each category you must have 3 values in [count sheet status].Do you really have 3 values for all data if not how will you identify status which is not completed (Third value).
2) if you wan to know count of [Count Sheet Status] why are you dragging both [Count Sheet Status] column and measure at the same time .
3) Please share give screent shot for data with only one category where you are facing issue so that it will help to understand problem
Sorry if I counfuse you.
Thank you so much
Ok Then you aplly left outer join on teh both the tables you will get null values with (no data in your case) then not count measure will measure these records.
Hi @Anonymous,
Is this issue resolved if yes please Accept as a solution
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |