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
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors