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.
I have three tables:
Putting both in table-visuals and adding customerID from Customers, I can click on a customer in either of them and get the same customers record in the other. Fine!
But; I want to add a slicer based on the values inLtd, and then "slice " the actual customers in both tables, not only in Ltd as I do by now. How can I relate Ltd to Std (and the opposite) to use slicer values from both tables to get the common customers?
Solved! Go to Solution.
In that case I would probably look to Power Query rather than DAX. Reference the query which pulls std, remove the columns you're not interested in and then remove duplicates. do the same for ltd and merge the 2 queries. you will then be able to link that new table to both std and ltd
you could create a new dimension table, something like
All values =
DISTINCT (
UNION (
ALLNOBLANKROW ( 'long term deals'[values] ),
ALLNOBLANKROW ( 'short term deals'[values] )
)
)
and then link that to both tables and use it in slicers and visuals.
Thanks, that works in the case where I slice on the values of the deals.
Then on Std I also want to slice on the product name, (so that selecting a product in Std also shows the Ltd's for the customers having both), how do I create the dimension table in that case? It will need two columns, value and productname, where productname is filled with NULL's from Ltd but I don't see how I can create that table using ALLNOBLANKROW..
In that case I would probably look to Power Query rather than DAX. Reference the query which pulls std, remove the columns you're not interested in and then remove duplicates. do the same for ltd and merge the 2 queries. you will then be able to link that new table to both std and ltd
Create a slicer from the Customers table and add a filter to it such that the customer ID from Ltd is not blank.
Ok, bad explaining from my side, I want to slice based on the values of the deals, not on the customerID's. And when slicing on the values of the Ltd's, I want the Std's to be sliced as well.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |