TREATAS combining filters

[Evelin_]

Hello Community! 

I did not find any proper topic for my question, can you help me?

I started to use TREATAS in some of my dax, intead of selectedvalue as Im developing with more function my dashboard.Now I should filter for not only versions but also for a different column, and I could not connect it with TREATAS. 

So far I had this formulas working:

VAR 1 =

CALCULATE (

    SUM ( Data[Volume] ),

    Data[Version] = "PLAN"

        && Data[PACK] = "BOX"

)

VAR 2 =

CALCULATE (

    SUM ( Data[Volume] ),

    Data[Version] = "PLAN"

)

VAR SHARE = DIVIDE(1, 2, -1) +0

How Can I turn it into a workinf formula with TREATAS? I can not join the PACK filter in this:

VAR 1 =

CALCULATE (

    SUM ( Data[Volume] ),

    TREATAS ( VALUES ( Version2[Version2] ), Data[Version])

PACK???

)

VAR 2 =

CALCULATE (

    SUM ( Data[Volume] ),

    TREATAS ( VALUES ( Version2[Version2] ), Data[Version])

)

VAR SHARE = DIVIDE(1, 2, -1) +0

Thank you in advance!

Evelin

[Evelin_]

Thank you! this works, and actually easier thank I thought 😄

[pankajnamekar25 · Accepted solution]

Hello @Evelin_ 

You can use below DAX code

VAR _1 =

CALCULATE (

    SUM ( Data[Volume] ),

    TREATAS ( VALUES ( Version2[Version2] ), Data[Version] ),

    Data[PACK] = "BOX"

)

VAR _2 =

CALCULATE (

    SUM ( Data[Volume] ),

    TREATAS ( VALUES ( Version2[Version2] ), Data[Version] )

)

VAR SHARE =

DIVIDE ( _1, _2, -1 ) + 0

RETURN

    SHARE

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.