Forum Discussion
Exclude values depending on the selected month
Hey there,
I want to calculate the amount by month but excluding certain values depending on the selected month in the filter. Example of my data:
What I ask for is to filter the amount of certain accounts depending on the month, for example:
In January I don't want to sum the amount of the accounts 1001, 1002 and 1003, in february 1003, 1004, 1005, in march 1002,1005,1007, etc...
I'll present the result in a card and it'll depends on the selection of the month in the slicer.
Thanks in advance.
2 Replies
- amitchandak
Super User
Anonymous , Assuming both are joined to a common date table you can try like
Measure = CALCULATE(COUNTX(filter(Table1,Table1[Account] in EXCEPT(ALLselected(Table1[Account]),ALLselected('Table 2'[Account]))),Table1[Amount]))Table 2 contains account to be excluded monthwise
