Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to calculate out of store count If I ahve data where I ahve store inv and store number and item

Batraquery_0-1682107635796.png

 

1 ACCEPTED SOLUTION

Hi, @Anonymous 

 

You can try the following methods.

vzhangti_1-1682390984903.png

Measure = CALCULATE(COUNT('Table'[STORE-SKN]),FILTER(ALLEXCEPT('Table','Table'[SKN]),[Inventory]<=0))

vzhangti_2-1682391013459.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

want to calculate another col with count of Out os stock store by SKN. total count of store for each skn

Hi, @Anonymous 

 

I have modelled some of the data to hopefully match your situation.

vzhangti_0-1682315160039.png

Measure = CALCULATE(COUNT('Table'[STORE-SKN]),ALLEXCEPT('Table','Table'[SKN]))

vzhangti_2-1682315222208.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

 

 

Anonymous
Not applicable

above calculation gives me Count of stores for an SKN, can we add count store with inventory less then or equal to 0. this will give stores out of inv for SKN. 

 

Hi, @Anonymous 

 

You can try the following methods.

vzhangti_1-1682390984903.png

Measure = CALCULATE(COUNT('Table'[STORE-SKN]),FILTER(ALLEXCEPT('Table','Table'[SKN]),[Inventory]<=0))

vzhangti_2-1682391013459.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

Based on the data you have provided, what kind of output do you expect?

 

Best Regards,

Community Support Team _Charlotte

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.