Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago
Solved

Numbers 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 !
  • souvik900766's avatar
    souvik900766
    5 years ago

    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

  • souvik900766's avatar
    souvik900766
    Icon for Helper IV rankHelper IV
    5 years ago

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