Forum Discussion
Solved
Filtering a table on multiple columns and rows - more efficient solution needed
Hi, I am looking for a more efficient solution. I have a table which contains all invoice numbers. Besides the invoice number the table contains as well three additional columns Case Number:...
hanssonnor , Try a measure like this.
This should give not in "T","W"
countx(filter(summarize(Table, Table[Invoice],Table[Case Number], "_1", calculate(count(Table[Solution]),table[Solution] in {"T","W"})+0),[_1]=0),[Invoice])
hanssonnor , Try a measure like this.
This should give not in "T","W"
countx(filter(summarize(Table, Table[Invoice],Table[Case Number], "_1", calculate(count(Table[Solution]),table[Solution] in {"T","W"})+0),[_1]=0),[Invoice])