Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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:
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!
View solution in original post
@Poupouh , distinctcount will be calculated again at grand total so it will not be a sum of rows
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.