Forum Discussion
Resolver IHow to do a new column with string values that come from different segmentations on the same data
I got the idea! Thanks lbendlin , Ill try to make it work! 🙏
Super UserYour example uses a combination of filters ( AND ).
By coincidence it matches the values in the other tables, but what you actually want to achieve is a collection of independent results ( OR ). You can only do that with a measure that tests for
[Market Value] > 0 || [Negotiation Volume] > 0 || [P/BV]> 0 || [Volatility] > 0
The || is what DAX uses for " OR " .
Resolver IHi lbendlin , thanks for your answer! Ahh these filters were "leftovers" from an earlier attempt of mine, in fact the reason why it matches exactly the values in the other tables is because I've filtered the Asset List in order to show the selected values, here:
Using your description, my goal would be an (AND) filter type, like if I told Power Bi to do this:
"Give me a column that aggregates dynamically the names of the Assets filtered by:
- the P/BV ranking (AND);
- the ones filtered by the Market Value ranking (AND)
- the ones filtered by the Negotiation Volume ranking (AND)
- the ones filtered by the Volatility ranking
I just have no ideia how it could be done with DAX 😅
- lbendlin
Let me repeat - what you need is an OR filter, not an AND filter.
- LucaixBolha
Hmm I see 🤔 ...I understand the idea of a collection of independent results, but when I tried it showed me this:
TTEN3 is the only Asset Code that appears because it is the only one that is within the range established by the four orange slicers. Were you picturing something like this (a calculate measure, applying the filters as you've mentioned)?
- lbendlin
Yes, that requires a measure which you then use as a filter on the visual