Forum Discussion

shyammayhs's avatar
shyammayhs
Advocate II
5 years ago
Solved

Use filters on a Measure table

Hi,

 

I have created a table that only holds Measures which uses fields from another table and I want to be able to use filters on the Measures. But it doesnt seem to work at the moment? Do I need to create a join/relationship between the tables?

 

The reason why I have created a Measure table is so that I can manage the Measures easily as well as be able to create a custom table with the right format... etc show Sold Volume (num) and Sold % after it, in the table. How do I make the filters work with this?

 

Thanks.

Need Help

7 Replies

  • shyammayhs's avatar
    shyammayhs
    Advocate II
    5 years ago

    Hi vivran22 

     

    So I want to be able to use filters on the Measures (measure table) that I have created - but at the moment, no filters seem to be working with the Measures?

    • vivran22's avatar
      vivran22
      Community Champion
      5 years ago

      shyammayhs ,

       

      I still do not understand in what scenarios you will like to filter the measures? Measures return scaler values, and you can only use them in the values segment of a visual (along with tooltips). 
      The table created to store the measures are not essentially a regular data table. 

       

      Is it possible for you to demonstrate with an example? Do you mean that you want to use meausres in slicer and then by changing selection different measures, it shows different results on the same visual?

       

      Cheers!
      Vivek

      If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
      If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

      Blog: vivran.in/my-blog
      Connect on LinkedIn
      Follow on Twitter

       

  • shyammayhs's avatar
    shyammayhs
    Advocate II
    5 years ago

    Hi vivran22 

    So, I have a table which holds the data.

    I have then created another Table that holds just the Measures - for example '=sum(VolumeSold)'.

    I have then added these Measures onto the dashboard as a chart. (At this point, the Measure table and the Data table are not joined or have any relationship)

    I am now trying to add in Filters from the data table onto the dashboard (Dates etc) but when I select a value from the filter, the Measure I have added to the chart doesnt update.

     

    Hope that helps clear it up.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi shyammayhs ,

     

    Do you have ALL() function in your measure? Are you using visual level filter or page level filter?

    Please show more information to us.

     

    Best Regards,

    Jay