Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure filters

Hi everyone,    I'm new with this account because I work at a different company now. I have some experience with Power BI.  I made a card with filters which gives me an outcome. I want to calculat...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , I doubt the calculation, Correct the syntax at few places. Try

afname aantal =
CALCULATE(
SUM('table'[amount]),
FILTER('table','table'[CallType]="AFNAME" && 'table'[Productcheck]="1" && 'table'[UnitCheck]="1"
&& 'table'[status_contreader] in {"Actief" ,"Leegstand"} && not('table'[STATUS] in {"Geannulr" ,"Gennul"}) && 'table'[status_line] in {"Actief" ,"Leegstand" }))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak  sorry for the late reply, I have a seperate 365 account on which I don't receive email, only for power BI, so I didnt see your response. Unfortunately it didnt work, I get the same error. I'm going to look into it some more myself. Maybe I can do it some other way.