Forum Discussion

Evelin_'s avatar
Evelin_
Icon for Helper I rankHelper I
1 year ago
Solved

TREATAS combining filters

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 das...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    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.

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
1 year ago

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.