Hi , I have 4 columns with A,B,C,D and i have filters with A,B,C,D Have to create a column or measure with sum(A),count(B),Count(C),Count(D) the output have to display only that value when i click o...
JAVED,
I make a test in the following sample table.
Firstly, create a new table as below.
Secondly, create the following measures in the Table1.
SUMA = SUM(Table1[A])
COUNTB = COUNT(Table1[B])
COUNTC = COUNT(Table1[C])
COUNTD = COUNT(Table1[D])
Measure = IF(SELECTEDVALUE(Table2[Column1],"")="A",[SUMA],IF(SELECTEDVALUE(Table2[Column1],"")="B",[COUNTB],IF(SELECTEDVALUE(Table2[Column1],"")="C",[COUNTC],[COUNTD])))
After the above steps, you can create slicer as below.
If you don't get expected result using above steps, please share sample data of your table here and share desired result based on the sample data.
Regards,
Lydia