Only show in report based on combined filters

[PeterStuhr]

Hello!

I have following table:

Opportunity ID	Deal Type	EUR	ShowInReport?
1	Normal	1000	No
2	Normal	2000	No
3	Normal	3001	Yes
4	Normal	1000	No
5	Normal	5000	Yes
6	Normal	2000	No
7	Normal	1000	No
8	Normal	5000	Yes
9	Normal	5000	Yes
10	Normal	1000	No
11	TECH	2000	Yes
12	TECH	5000	Yes
13	TECH	1000	Yes
14	TECH	5000	Yes
15	TECH	1000	Yes
16	TECH	2000	Yes
17	TECH	1000	Yes
18	TECH	2000	Yes
19	TECH	3000	Yes
20	TECH	1000	Yes

In our Power BI Report we only want to include deals above 3000 EUR. However, if the deal type is "TECH" it should show no matter what. Is it possible to make add a column like the one called "ShowInReport?" ? It should have the output showing in the example.

[v-juanli-msft · Accepted solution]

Hi @PeterStuhr 

Create such column

Column = IF([Deal Type]="TECH"||[EUR]>3000,"Yes","No")

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.