Forum Discussion
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 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
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.
2 Replies
- pankajnamekar25
Super User
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_Thank you! this works, and actually easier thank I thought 😄