Forum Discussion
Solved
Filtering many columns and also date
Helllo, what is best practice to filtering several strings from same, as also from different columns, while also having a date condition? Is it possible to put it in one Measure straightforward?: ...
Hi Applicable88
You can apply multiple conditions in a measure, it depends on how you would like to visualize your result. Based on your sample data, a card to show it
Total Sales = SUMX(FILTER(yourTable, yourTable[Date]>DATE(2021,01,16)&&yourTable[Category]="Clothing"&&yourTable[Size]="M"&&yourTable[Color]in{"green","black"}),yourTable[Sales])
If I understand you correctly, with that approach I can wrap up a typical search() function into a measure using generate to build an extra "virtual" column ?
Yes, have a try:)