Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello!
I am quite new to Power Bi and I am currenlty experiencing trouble with the DISTINCTCOUNT function.
What I am trying to do is quite easy, counting the distinct number of customer excluding the negative and nul numbers.
My formula is the follwing:
Solved! Go to Solution.
Thank you for the reference. I managed getting the good number via a If and Summarize function.
Again, thank you for your help!
Thank you for the reference. I managed getting the good number via a If and Summarize function.
Again, thank you for your help!
@Poupouh , distinctcount will be calculated again at grand total so it will not be a sum of rows
refer: https://www.youtube.com/watch?v=ufHOOLdi_jk
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!