Skip to Content

Using filter with measures calculated from the modeller or from history

Hello everyone. I have a doubt about using filters in history with measures calculated from the modeller, specifically with the tables. When the filter is activated the measure let the blank field. But if i take the value from the database the field dissapear. I wanna that the field from the modeller dissapear from my table.

Can be possible achive that?

Regards.

111111.png

2222222.png

111111.png (43.1 kB)
2222222.png (18.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 07 at 07:53 AM

    Hi Juan,

    I wonder if it's related to the linking of both models. It is possible that the filter is only applied to the dimensions of one model.

    If you link both models using also currency, does it work?

    Regards,

    Julian

    Add comment
    10|10000 characters needed characters exceeded

    • This must be related to the calculation.

      Try exploring the data using Data View and select only measures and check the behaviour when you add those calculations (formulas created in the model). It is possible that some have restrictions on the dimension selected, in this case the currency.

      Regards,

      Julian

  • May 01 at 07:59 PM

    Hi Juan,

    Do you have the Unbooked feature set in the Row or column dimensions?

    Add comment
    10|10000 characters needed characters exceeded