cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Iklizo
Helper III
Helper III

store not selling

Hi All,

I need help on how to calcuate Stores that are not selling in a DAX measure. Not sample data. I just need DAX formular. here is my Query

Store Not selling =
CALCULATE(COUNTROWS(VALUES(table[Stores])),
[sales]= 0)
Iklizo_0-1653257895657.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Iklizo 
Please use

MyMeasure =
CALCULATE (
    COUNTROWS ( VALUES ( Site[Site Corporate Number] ) ),
    FILTER ( Site, [sales] = 0 )
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Iklizo 
Please use

MyMeasure =
CALCULATE (
    COUNTROWS ( VALUES ( Site[Site Corporate Number] ) ),
    FILTER ( Site, [sales] = 0 )
)
Fowmy
Super User
Super User

@Iklizo 

Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors