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.
Hello Trying to get a top n and others calculation going on for some visuals I created a calculated table to get distinct names from a client table using this
How can i fix this? the client type table has a relationship with the sales values table if I use the customer names from the client Type table I have no problems the only thing I don't have a "Others"row
Solved! Go to Solution.
This woks but not what I was looking for since I am crating a top n with an "Others" row. I found the solution by creating another measure:
Thanks for your help!!
Hi @Anonymous ,
If not want to use the relationship in the previous table, you can create the calculated table like this:
Customers Plus Others = UNION('ClientType','Customers')
Create the total measure:
Total =
CALCULATE (
SUM ( 'Sales Values'[Tonnage] ),
FILTER (
'Sales Values',
'Sales Values'[ID] IN DISTINCT ( 'Customers Plus Others'[ID] )
)
)
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.
This woks but not what I was looking for since I am crating a top n with an "Others" row. I found the solution by creating another measure:
Thanks for your help!!
This woks but not what I was looking for since I am crating a top n with an "Others" row. I found the solution by creating another measure:
Thanks for your help!!
@Anonymous See if this works.
Table # 1
Table # 2
Table # 3 (Sale Fact)
Union Table (DAX)
Result
If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.
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.