Pleas be aware that the table is defined w/o a table name and w/o a name for the column. I'm fairly new to Power BI and could really use some help. This could result in much better performance in scenarios where an arbitrary shaped filter is required, especially when you combine columns from different tables. Return Order Count:=CALCULATE([Order Count],FILTER(counter sales data,counter sales data'[Order Type]=CO))+CALCULATE([Order Count],FILTER(counter sales data,counter sales data'[Order Type]=CR)). Could someone please help me write it correctly? If the expression evaluates to true, the row is "kept.". You can find more details about the internal behavior and the related performance in The Definitive Guide to DAX. Returns a table that is a crossjoin of the specified tables. Would I need to make a relationship between the two? Read more, We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE. CROSSJOIN (
[,
[, ] ] ), Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter), Send me SQLBI promotions (only 1 or 2 emails per year). I will edit my post immediately. @mculloa{} are required to indicate that you are creating a list of items. * filter OUT (do not add in the sum) the combination of 2 filters on 2 other columns: the value "1" on column "Is a partner order" and the value "1" on column "Flag partner". Evaluates an expression in a context modified by filters. StatusPT1 = Hi Ashley, Thanks for replying. basically my first post contains a typo (I have been in a hurry). Here I mean that having one of them true is fine, the values I want to exclude are the ones where BOTH filters combined are true (1 AND 1). Folder's list view has different sized fonts in different folders, one or more moons orbitting around a double planet system. In this case you have to write an explicit table expression instead of relying on automatic conversion of a logical expression in a table expression made by CALCULATE and CALCULATETABLE when you reference a single column. The following Sales table measure definition produces a ratio of sales over sales for all sales channels. Why are players required to record the moves in World Championship Classical games? Marco is a business intelligence consultant and mentor. However, it requires the relationship to be defined in the data model. Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. I already tried some options suggested in this forum like the ones appointed by@amitchandakin this previous posthttps://community.powerbi.com/t5/Desktop/Filter-data-based-on-multiple-criteria-in-same-column/m-p/2,but for some reason, my DAX doesn't work.
