Thanks for your answer orcllover, i tried that but appears an error because the 'filter using' just work if the filter is by a dimension and i need filter the fact where a meassure is > 0.
First what version are you talking about?
So you are saying you duplicate the LTS and you don't see it? Do you maybe have a screenshot?
I would say you better set the mapping to logical columns in the LTS instead of the column. In that case you can't not see the LTS as you are using it and so you don't even have to question yourself if you see it or not.
I think what they are suggesting is; -
1. In Business Model layer duplicate your existing measure and give the duplicate an appropriate name
2. Edit the formula on the new measure, applying the filter as shown in the first post, after all it can be based on physical measure and you can reference other measures, or use case logic or similar to give you similar functionality
3. Drag it into the presentation layer in the appropriate place
If 2 cannot explain for you then kindly provide further detail as to why?
What you see is right, because as you said the physical table is the same one
And the last screenshot on the right you are inside the LTS, so you set your column to the formula you want and you maybe want to cancel all the others.
I guess you want your "moderadora" LTS to source only the logical column "personas unicas moderadora", so there in the last screenshot on the right cancel all other mappings on other columns, and set it on the column you want (or formula) for the "personas unicas moderadora".
If you then open the logical column itself you will see it's sourced from that LTS while all the others are sources from the other LTS.
But what you see is right: on the physical side of things the table is always the same
Thanks a lot Gionni. It works perfect !!!