Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
wow, I can't upload my project file here..... huh this is going to make things difficult
Two tables with a relationship. Table A has an amount column and I have a donut chart summing that amount by name.
Table B is a related table.
Table B has a column that I wish to filter the donut chart on
I only get 1 result This is the generated DAX I caputed from Performance Analyzer
// DAX Query
DEFINE
VAR __DS0FilterTable =
TREATAS({"A"}, 'Table2'[Type])
it goes south here as this returns just 1 record so the TOPN is performed on a table of 1
VAR __DS0Core =
SUMMARIZECOLUMNS('Table1'[Name], __DS0FilterTable, "SumAmount", CALCULATE(SUM('Table1'[Amount])))
VAR __DS0BodyLimited =
TOPN(1002, __DS0Core, [SumAmount], 1, 'Table1'[Name], 1)
EVALUATE
__DS0BodyLimited
ORDER BY
[SumAmount], 'Table1'[Name]
I'd upload the project because that would be simplier but I see no upload link.
Solved! Go to Solution.
I changed the properties on the relationship. The value for Cross Filter Direction was changed to "Both" and configured the filter for both directoins (checkbox) and now appears to be functioning.
Hey @iooab1- ,
upload the pbix file to onedrive or dropbox and share the link.
Regards,
Tom
I changed the properties on the relationship. The value for Cross Filter Direction was changed to "Both" and configured the filter for both directoins (checkbox) and now appears to be functioning.
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |