Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I create a table using the DAX expression
RegionalOverallPerformance = // An intermediate table to show the Ranking by the Overall performance of Regions SUMMARIZECOLUMNS ( dimRegionsCountries[Region], "OveralPerformanceYTD", [Overall Performance YTD], )
I get the table with the columns I want but the results of the two measures are incorrect, compared to the table visual.
Only the first record is correct.
What might be the reason?
Thank you,
Tamir
Solved! Go to Solution.
Hi Tamir,
The [Overall Performance YTD] seems to evaluate along the dates while you don't have a date context in the new table.
What's the expected result?
Did the table visual have the same column against the new table?
Best Regards,
Dale
Hi Tamir,
The [Overall Performance YTD] seems to evaluate along the dates while you don't have a date context in the new table.
What's the expected result?
Did the table visual have the same column against the new table?
Best Regards,
Dale
Your answer pointed me to the time element direction and the culprit was found to be a year field = 2018 in the page level filter.
I added that FILTER condition in the calculated table and that solved the problem.
However, I don't understand why does the page level filter has no effect on the calculated table.
Thank you,
Tamir
Hi Tamir,
That's great. First of all, the filters and the slicers don't work with the calculated tables. The calculated table is the source of the report just like other data tables.
Best Regards,
Dale
Hi Dale,
I don't follow your answer.
Page level filter does affect "regular" tables. Why not calculated tables?
Thank you
Tamir
Hi Tamir,
Page Level Filter doesn't affect "regular" tables that are the data sources rather than the Table visuals. Please refer to the snapshot below. Generally, we can take the calculated tables as regular tables.
Best Regards,
Dale
Thank you Dale,
I understand better now.
However, it seems that the page filter does not affect the Table Visual that is based on the calculated table.
Regards,
Tamir
Hi @Tamiri,
That could be an issue. Can you share an example? It's good in my side. Please refer to the snapshot below.
Best Regards,
Dale
Hi Dale,
In the page filter, I put the Year field and set it to 2018.
In my table visual, that is based on the calculated table, there is no date.
I guess that is the reason...
However, I thought that that calculated table will be affected by that date page filter since it should filter the dates of the calendar which feeds the measures that are used to build the calculated table.
Thank you,
Tamir
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |