Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
432 views
in Technique[技术] by (71.8m points)

powerbi - CALCULATE - how does AND logic work when multiple FILTERS are used?

When there are multiple filters, they're evaluated by using the AND logical operator. That means all conditions must be TRUE at the same time.

I understand this when the filters are like: AMOUNT>100, CATEGORY='Sales'

However, when one or all of the filters are given by FILTER formula, I am unable to visualise how the AND logic works (and what does all conditions must be true mean because a condition [FILTER] itself is a table). Please can you give an example.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

All of the filters will be part of an expanded table and ultimately each condition is a set of rules for specific columns on this expanded table.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...