topic Re: Context filtering in DAX Commands and Tips

Context filtering

Tom_Y — Thu, 07 Dec 2023 09:35:27 GMT

I'm a begginner learning "context filtering".

[Filter Red] is a Calculated Column. Other 3 columns are mannually input. What's the logic behind it's showing answers in rows with colour Orange???

Thanks in advance.

Re: Context filtering

ray_codex — Thu, 07 Dec 2023 09:44:04 GMT

You are basically doing this:

Ignore the row I'm in (use of calculate) then create a new context by filtering column colour by the value "Red". If this is done, take the total of the count column.

Re: Context filtering

ChiragGarg2512 — Thu, 07 Dec 2023 09:49:01 GMT

Tom_Y Try this Dax:

Filter Red = If('Table'[Color] = "Red", CALCULATE(sum('Table'[Count]), 'Table'[Color] = "Red"), BLANK())