Forum Discussion

NovaBI's avatar
NovaBI
Icon for Post Patron rankPost Patron
6 years ago
Solved

Best practice multiple filters, with measures

Hi peeps,   i try to describe my issue as good and as clean as possible:   I imported a dataset from SAP via Import 2.0.   Therefore i have an "amount" column from which the current numbers are...
Need Help
NovaBI's avatar
NovaBI
Icon for Post Patron rankPost Patron
6 years ago

forgot the minus here:

 

I tried sth. like XYZ =

Calculate(Sum(table1)[Amount]), Filter[table1,table1[CY Testcode])

    %

       Calculate(Sum(table1)[Amount]), Filter[table1,table1[PY Testcode])