Forum Discussion
Solved
COUNTX (Column with multiple duplicate values)
Hi, I am still very new to DAX and I am currently trying to get better with the formulas. My questions is that I have a column [Reference Numbers ] that has various duplicates due to itemization bu...
- Calculate( DISTINCTCOUNT('ClaimsData'[Reference Number]), Filter('ClaimsData', 'ClaimsData'[Year]=2021))It would be great if you were using a separate data table thats a basis of any report.
Here you can read more on that https://learn.microsoft.com/en-us/dax/calendar-function-dax
Calculate( DISTINCTCOUNT('ClaimsData'[Reference Number]), Filter('ClaimsData', 'ClaimsData'[Year]=2021))
It would be great if you were using a separate data table thats a basis of any report.
Here you can read more on that https://learn.microsoft.com/en-us/dax/calendar-function-dax
Here you can read more on that https://learn.microsoft.com/en-us/dax/calendar-function-dax