Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Distinctcount with crossfilter issue

Good afternoon, I have an issue that I can solve.   I have this code :  CALCULATE(COUNTX(FILTER(Base_PBI,Base_PBI[Date1]<=max('new measure'[Date]) && ((Base_PBI[Date2]>DATE(YEAR(TODAY()),month(t...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

CALCULATE(CALCULATE(DistinctCOUNT(Base_PBI[Ent]),CROSSFILTER(Base_PBI[Date1],'new measure'[Date],None)),FILTER(Base_PBI,Base_PBI[Date1]<=max('new measure'[Date]) && ((Base_PBI[Date2]>DATE(YEAR(TODAY()),month(today()-1),31)) || Base_PBI[Date2]>max('new measure'[Date]))))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you but it doesn't work, I still have the same false number.

    Perhaps is because of the function distinctcount no? What I want is to count all my lines but one time, like if there are three times the same value in the column "ent", I want to count it as 1. Maybe Discountcount count only the value that are unique? It can be?
    Thank you