Custom total and subtotal

[MikeRu]

Hellow.

I have dax in calc clumn value

budget =

VAR _ret = CALCULATE([Сумма ]/1000, 'ovip_fact_budget'[measure] = "budget " ,'ovip_fact_budget'[data_type] = "bud")

VAR _show = [isShow]

return (SWITCH(TRUE(),

_show= "other", 0,

_ret)

)

When I try to show total in table I get value error value. Because Summaraze works on both conditions in formula.

Is there any way to add some custon total and subtotal ?

[Mahesh0016]

@MikeRu ,

budget =

VAR _ret = CALCULATE([Сумма ]/1000, 'ovip_fact_budget'[measure] = "budget " && 'ovip_fact_budget'[data_type] = "bud")

VAR _show = [isShow]

return (SWITCH(TRUE(),

_show= "other", 0,

_ret)

)

#################

budget =

VAR _ret = CALCULATE([Сумма ]/1000, 'ovip_fact_budget'[measure] = "budget " || 'ovip_fact_budget'[data_type] = "bud")

VAR _show = [isShow]

return (SWITCH(TRUE(),

_show= "other", 0,

_ret)

)

>> Try both formula , i hope helps . 
>> If this post helps, please consider accept as solution to help other members find it more quickly.

[MikeRu]

Thanks for replay.

But I have error in this case

[Mahesh0016]

@MikeRu Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.