Forum Discussion

MikeRu's avatar
MikeRu
New Member
3 years ago

Custom total and subtotal

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 ?
Need Help

3 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      MikeRu
      New Member
      3 years ago

      Thanks for replay.

      But I have error in this case

      • Mahesh0016's avatar
        Mahesh0016
        Icon for Super User rankSuper User
        3 years ago

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