Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying create a new column that comfirms if a customer has bought product from both distributors. An example data set is below. Most companies only by one from distributor, however there are some that buy from both. I want to be able to filter out the custoemrs that buy from both distributors.
The columns I'm using below are 'Customer'[Customer Name], 'Distributor'[Distributor Name] and 'Key Measures'[Revenue].
These columns also exist in my fact table (called 'Orders'). eg. 'Orders'[Customer Name], 'Orders'[Distributor Name] etc.
I understand that this will most likely involve nested IF AND statements, but I am unable to get it to work!
Does anyone have tips to point me in the right direction?
Solved! Go to Solution.
Hi @LewisB ,
Sorry for replying late. You can create a measure liek this, put it in the visual filter and set its value as 0:
visual control =
IF (
COUNTX (
FILTER ( 'Key Measures', 'Key Measures'[Revenue] <> BLANK () ),
[Customer]
) >= 2,
1,
0
)
Attached a sample file in the below, hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LewisB ,
Sorry for replying late. You can create a measure liek this, put it in the visual filter and set its value as 0:
visual control =
IF (
COUNTX (
FILTER ( 'Key Measures', 'Key Measures'[Revenue] <> BLANK () ),
[Customer]
) >= 2,
1,
0
)
Attached a sample file in the below, hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Would nested IF statements be better in this regard?
I have tried the below formula, however it just shows up as "No" for all rows:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |