Numbers not coming in matrix after using selectedvalue.

souvik900766 — Sat, 03 Jul 2021 03:16:57 GMT

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 !

Re: Numbers not coming in matrix after using selectedvalue.

souvik900766 — Sat, 03 Jul 2021 04:06:04 GMT

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

topic Numbers not coming in matrix after using selectedvalue. in DAX Commands and Tips

Numbers not coming in matrix after using selectedvalue.

Re: Numbers not coming in matrix after using selectedvalue.