Exclude 1 Attribute with Total still running

[Anonymous]

Hii PBI Maestro

I have calculation in matrix but the total to be zero when I exclude 1 attribute (PUSAT).
my goal I wanna exclude 1 attribute (PUSAT) without missed the running total.

BO1 = 
var y = COUNTROWS(FILTER(SUMMARIZE(SALES, master_BP[BP]),master_BP[BP] <> BLANK()))
var x = IF(HASONEVALUE(master_SC[Reg Short]),MAX(master_SC[Reg Short])<>"PUSAT",BLANK())
var z = CALCULATE(IF(x=False,0,y),ALL(Sales))
RETURN
IF(x=False,0,y)

[Ritaf1983 · Accepted solution]

Hi @Anonymous  you can use formula like mine (just modify with your parameters) :

cumulative_Whitd_d_0 =

if (HASONEFILTER('Table'[category]),

 if (max('Table'[category])="d",0,

 CALCULATE(

       [sum_],

        FILTER(

            ALL('Table'),

            ISONORAFTER('Table'[category],max('Table'[category]),DESC)

        ))),

       CALCULATE(

       [sum_],

        FILTER(

            ALL('Table'),

            ISONORAFTER('Table'[category],max('Table'[category]),DESC)

        ),'Table'[category]<>"d"))

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly