Forum Discussion

david_blabla's avatar
david_blabla
Frequent Visitor
4 years ago

Filter does not work on calculated column

Hi all,   I ran into a problem recently and hope that someone knows what I am doing wrong: I have two data sets which are mapped by an ID. The element dataset looks like this: element summar...
Need Help
smpa01's avatar
smpa01
Community Champion
4 years ago

david_blabla  if I understand it correctly,

 

you created 'Summary Finish Date' calculated column in 'summary'

and

in your data model 'summary' filters 'element' in 1 to Many.

 

In the viz, you brought all your AXIS (columns) from 'summary' and expects that Viz to be sliced by an element (element type) from 'element'.

 

Since 'element' does not filter 'summary' that slicer would not work.

 

In order to make it work,

you can build an 'element type' table and connect it to 'element' 

and

write a measure 

and

bring your AXIS from both 'summary' and 'element type' table

and 

bring slicers from all the dimension tables ('summary','elemnt type')

 

 

 

  • david_blabla's avatar
    david_blabla
    Frequent Visitor
    4 years ago

    Hi smpa01,

     

    smpa01 wrote:

    Since 'element' does not filter 'summary' that slicer would not work.

    That sounds very promising.

    Unfortunately, I did not understand your solution. Can you maybe elaborate a bit more?

     

    Thanks,

    David

    • smpa01's avatar
      smpa01
      Community Champion
      4 years ago

      david_blabla  I am guessing your DM looks like this

       

       

      The flow of filter (arrow) is from summary to element, which means only columns from summary can slice anything from element, summary can slice summary. But element can't slice sumamry unless you make the filter bi-directional (which is not recommended) but then it introduces a lot of ambiguity in the model.

       

      What I have suggested is this. When building viz, bring all the axis and slicers from from 'elementType' and 'summary'; create a measure on 'element' and drop that on the axis.  Slicer can easily slice them.