Numbers not coming in matrix after using selectedvalue.

[souvik900766]

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 !

[souvik900766 · Accepted solution]

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]))))