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.
Hey all,
in the image below I have a example for you of my problem.
I have two tables, the first is the cusomer Table(A,B,C).
The second is the sold items Table. That was easy!
The last table I want is the items which a customer didint sell.
As you can see in the left table, customer A buy Coca Cola, Sprite, and so on... . These items should not shown in the right table("Not sold items"). Only these items which the customer did not buy, like Fanta, Water, Apple, etc. should be shown on the Power BI table.
I need a Measure, I tried everything but I didint figure it out how it can be done.
Hope you understand and can help.
Thank you all!
Solved! Go to Solution.
Hi @azaterol ,
Create a measure like below:
Measure =
VAR tmp =
CALCULATETABLE ( VALUES ( 'sold items'[sold items] ) )
RETURN
IF ( SELECTEDVALUE ( 'not sold items'[not sold items] ) IN tmp, 0, 1 )
Then add this measure to visual filter and set value = 1.
Best Regards,
Jay
Hi @azaterol ,
Create a measure like below:
Measure =
VAR tmp =
CALCULATETABLE ( VALUES ( 'sold items'[sold items] ) )
RETURN
IF ( SELECTEDVALUE ( 'not sold items'[not sold items] ) IN tmp, 0, 1 )
Then add this measure to visual filter and set value = 1.
Best Regards,
Jay
@azaterol , You need to have separate item dimension, post that try this
Assume you have sales measure
if(isblank([sales]),1,blank())
Plot this with the item from a separate item dimension
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |