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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

Try:

CALCULATE( Sum(Tablename[Revenue]), ALLEXCEPT(Tablename, Tablename[Country] ) )

You could use the ALLEXCEPT function instead of the ALL function

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.