cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brite
Frequent Visitor

Count By Date

Hello,

 

I am currently trying to count cancellations by Month (By the Date in the data) and my DAX formula is spitting out the same number for every Month.  How do I fix this??? 

 

count_failcancelandrejected = calculate(DISTINCTCOUNT('Fail Cancel.Rejected'[Status]),'Fail Cancel.Rejected'[Status] = "Rejected" || 'Fail Cancel.Rejected'[Status] = "Fail Cancel")

Brite_2-1630005675835.png

 

Brite_3-1630005775078.png

 

 

Brite_1-1630005112975.png

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Brite ,

 

this part of your DAX

... DISTINCTCOUNT('Fail Cancel.Rejected'[Status]) ...

counts the distinct values from the status column.

 

For this reason, I consider the result correct.

 

Maybe you can prepare a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

 

Describe the expected result based on the sample you provide.

 

Hopefully, this provides at least a new idea on how to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

Hey @Brite ,

 

this part of your DAX

... DISTINCTCOUNT('Fail Cancel.Rejected'[Status]) ...

counts the distinct values from the status column.

 

For this reason, I consider the result correct.

 

Maybe you can prepare a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

 

Describe the expected result based on the sample you provide.

 

Hopefully, this provides at least a new idea on how to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.