Forum Discussion

ImJustConfused's avatar
ImJustConfused
Frequent Visitor
8 years ago

Creating a dynamic calculated column via slicer

I'm trying to create multiple slicers to filter my data. The first slicer is a date slicer. The second slicer is a count slicer. I have a categorical field, a binary field, and a date field. Similar ...
Mareias's avatar
Mareias
Frequent Visitor
8 years ago

Hello,

 

I had the same problem today. The calculated column cant be dynamic.

 

1. Calculation column/table not support dynamic changed based on filter or slicer. (So sum(table[column]) will return fixed value)
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

 

Try using a calculated measure and see if that suits you.

  • ImJustConfused's avatar
    ImJustConfused
    Frequent Visitor
    8 years ago

    Mareias Thank you for the suggestion. 

     

    I've tried using a calculated Measure, but I am unable to use that Measure in a slicer. Is there a different way that would help me achieve the same result?

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi ImJustConfused,

       

      You should manually create an extra table which is unrelated to fact data table to list all available count numbers for users to choose from.

       

      Create measures like below:

      NameCount = 
CALCULATE(
    COUNT('Test Table'[name]),
    'Test Table'[isOld] = 1,ALLSELECTED('Test Table'[Date]))+0

selected CountNo = SELECTEDVALUE(slicertable[CountNo])

check_ = IF([NameCount]=[selected CountNo],1,0)

      Add measure [check_] to visual level filter and set its value to 1.

       

      Best regards,

      Yuliana Gu