Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove partial filter context in Calculated column

Hi Folks, I want to build a data model as shown below: I want a calculated column "Revenue ignoring country" to show total revenue for each supplier(ignoring country-wise split).  How can th...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Write this calculated column formula (not measure)

    =calculate(sum(data[revenue]),filter(data,data[supplier]=earlier(data[supplier])))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Write this calculated column formula (not measure)

=calculate(sum(data[revenue]),filter(data,data[supplier]=earlier(data[supplier])))

Hope this helps.