Forum Discussion
souvik900766
Helper IV
Helper IVNumbers not coming in matrix after using selectedvalue.
Hi !
Refer The Pic:-
I cant understand why numbers are not coming in the second column ?
My Measure Used for second column,
Share CY FINAL = IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="ABC Tm",CALCULATE([ABC Tm Share CY],ALL('Ctg Sort Table')),
IF(SELECTEDVALUE('New Ctg Sort Table'[New Category Def])="SSD",[SSD Share CY],[Share CY]))
Thanks in advance for !
Thanks in advance for !
I am answering My Question only....
I have used selected value for Co and NC first and then ABC Tm and then SSD and then if false then share of all.Share CY FINAL = IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="ABC Tm",CALCULATE([ABC Tm]) Share CY],ALL('Ctg Sort Table')),IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="CO",[Share CY],IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="nc",[Share CY],IF(SELECTEDVALUE('New Ctg Sort Table'[New Category Def])="SSD",[SSD Share CY],[Share CY]))))
1 Reply
souvik900766I am answering My Question only....
I have used selected value for Co and NC first and then ABC Tm and then SSD and then if false then share of all.Share CY FINAL = IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="ABC Tm",CALCULATE([ABC Tm]) Share CY],ALL('Ctg Sort Table')),IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="CO",[Share CY],IF(SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="nc",[Share CY],IF(SELECTEDVALUE('New Ctg Sort Table'[New Category Def])="SSD",[SSD Share CY],[Share CY]))))