Forum Discussion
Evelin_
Helper I
Helper ITREATAS 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...
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Evelin_Helper I
Helper IThank you! this works, and actually easier thank I thought 😄