The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
On a table visual I have data with four values such as A, A, B, B. When I ask it not to summerise I find that it does summarise with results of only two rows.
Anyone have any ideas? This seems to have started after the last update to PBI.
Thanks in advance
Paul
Solved! Go to Solution.
Hi @DrBiker
A dimension will always be summarized based on its distinct values such as A will is displayed once no matter how A's a column has. You need to add a column to a table that returns a different value for each instance of A like an index column.
Go to Options and Settings, then Options:
Under Global, move down to Diagnostics, then under Query Diagnostics/Diagnostics Level, untick Aggregated.
Hope this will help you.
Hi @DrBiker
A dimension will always be summarized based on its distinct values such as A will is displayed once no matter how A's a column has. You need to add a column to a table that returns a different value for each instance of A like an index column.