Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all. I hve a question regarding PowerBI. I have 2 table visuals. Each one is based on a separate table, with a link by an index number. My intended result is to show which items from table 2 are not in table 1.
For example, in my 'master' table I have all the customers with a specific criteria (which may be a subset of a larger customer list). In my second table, I have customers with that specific criteria which have generated revenue for a filtered month. Some customers may not show revenue and woudl not be in that second table. I would like to see which items are missing from table 2.
More detail:
total customers=1,000
Table 1= master list of customers on a service contract which I expect to generate revenue each month
Table 2 = list of all customers with revenue, which I filter by month
I would like to see which customers are missing from table 2, i.e. haven't generated any revenue.
I hope that's clear.
James
Solved! Go to Solution.
Hi, @josborne
According to your description, you can try following measure as a filter in Table 1 visual filter pane.
MEASURE =
VAR _table1_customer =
SELECTEDVALUE ( 'Table 1'[Customer] )
VAR _table2_customer =
SELECTEDVALUE ( 'Table 2'[Customer] )
VAR _result =
IF ( _table1_customer <> _table2_customer, 1, 0 )
RETURN
_result
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Mate thank you very much this worked well.
Hi, @josborne
According to your description, you can try following measure as a filter in Table 1 visual filter pane.
MEASURE =
VAR _table1_customer =
SELECTEDVALUE ( 'Table 1'[Customer] )
VAR _table2_customer =
SELECTEDVALUE ( 'Table 2'[Customer] )
VAR _result =
IF ( _table1_customer <> _table2_customer, 1, 0 )
RETURN
_result
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
User | Count |
---|---|
85 | |
81 | |
67 | |
63 | |
54 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |