Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated column ..**Its urgent PLz****

Hi All,    Below is my table with data  Product Type Sales pen A 7 Pen A 9 Pen B 7 Pen B 4 Pen B 10 Pen B 5 Pen B 8 Pen C 4 Pen C 4 Rubber A ...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

Create a table as follows

TableAv = SUMMARIZECOLUMNS(TableXX[Type], "Obs", CALCULATE(AVERAGE(TableXX[Sales]), TableXX[Product] = "Pen") ,
                                          "Ruled" , CALCULATE(AVERAGE(TableXX[Sales]), TableXX[Product] = "Rubber"),
                                          "Pinned", CALCULATE(AVERAGE(TableXX[Sales]), TableXX[Product] = "Scale"))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thnks for ur reply ..

 

i have a filter with pen,rubber,scale .. so when i select the pen .. in the table only pen dax should excute or come . so when i select rubber & pen , in the table both rubber and pen data should come in column .. 

can you help out with this .. 

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    According to your description, what you want to achieve is to dynamically add or delete columns according to slicer.

    After the table is created according to HotChilli  said before, you can refer to using-a-slicer-to-show-different-measures.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.