Forum Discussion
Solved
DAX Formula Calculates Wrong Answer
Hi, I have two table. First table is Location, and columns names are Region Name,Site Name and Quantity. Other table's name is Data, and column names are Date, Site Name, and Value. There are...
tolgalogy , Try like
countx(FILTER (Values(Location[Region]), DayRange>2 && ISBLANK(DayRange)=False),[Region])
amitchandak
Super User
Super Usertolgalogy , Try like
countx(FILTER (Values(Location[Region]), DayRange>2 && ISBLANK(DayRange)=False),[Region])
Thank you amitchandak
I used your suggestion, and transform my code as
CALCULATE(
DISTINCTCOUNT (Location[Region],
FILTER (Values(Location[Region]),
DayRange>2 && NOT (ISBLANK(DayRange)
)
)
)