Forum Discussion

Companyuser101's avatar
Companyuser101
Helper II
4 years ago

Measure filter

  Hello, I have the field "Ziel AG (WHS)" which is a Sum.  I now want fo filter it with a measure. You see on the picture above that the Field Ziel AG WHS appears on on every line. I on...
Need Help
ToddChitt's avatar
ToddChitt
Super User
4 years ago

I bet that field is not related to rows you show, because it is showing 13 for each, event he total. Can you share your data tables and relationships?

Companyuser101's avatar
Companyuser101
Helper II
4 years ago

Hi, yes there is no relationship. In the "Ziel" data we dont have columns that could relate to the "model" date which ist agricultural date, compact tractors, and so on. 

 

  • Companyuser101's avatar
    Companyuser101
    Helper II
    4 years ago

    Hello again, 

    I changed the data a little bit: 

    Now I have a relationship: 

    My table now looks like this: 

    The WHS Plan now is correct for the different models (Agricultural Tractor, Compact Tractos, ...).

    But I'm not able to make a relationship with the second dimension 

    So here are still always the same numbers. 

    Can I filter the numbers from WHS Plan so they only appear on the first dimension and not on the following ones?