Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Strange Date filter behavior

Hello,  I have this model And this measure     Overall = VAR DoneIssues = CALCULATE(SUM(Issues[Weight]), Issues[Status] == "Done") VAR Total = CALCULATE(SUM(Issues[Weight]), Issues[S...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Please make Year to Epics join 1-M and then check .

 

Also try meausre like

 

Overall = 
VAR DoneIssues = CALCULATE(SUM(Issues[Weight]),filter(Issues, Issues[Status] == "Done"))
VAR Total = CALCULATE(SUM(Issues[Weight]), filter(Issues,Issues[Status] <> "Cancelled"))
VAR Ratio = DIVIDE(DoneIssues, Total)
RETURNS
IF(ISBLANK(Ratio), 0, Ratio)

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello amitchandak, thanks for your answer. 

I tried the changes you mentioned but the behavior is the same. 
Anyways, I believe that the expanded Issues table contains the attributes of Date table regardless if the relationship is 1:1 or 1:*.  If it was a FILTER(Issues,... ) thing the behavior would have been wrong when filtering by Epics[Date]. 

Obviously if I remove the IF statement in my measure, it returns BLANK and the row disappears, but that is not the real solution. 

I dont know what could be happening. More opinions are appreciated.