Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to Solution.
Hi @Anonymous
Please use
MyMeasure =
CALCULATE (
COUNTROWS ( VALUES ( Site[Site Corporate Number] ) ),
FILTER ( Site, [sales] = 0 )
)
Hi @Anonymous
Please use
MyMeasure =
CALCULATE (
COUNTROWS ( VALUES ( Site[Site Corporate Number] ) ),
FILTER ( Site, [sales] = 0 )
)
@Anonymous
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.