Forum Discussion
Power BI Table Average Total Incorrect
Hi, I selected a table from the visualization options. After adding my columns as an average rather than sum, I am receiving the wrong total. If that is just the way the calculation works for averag...
Hi Anonymous ,
Using values('Table[name]) instead,see below example:
Measure total = SUMX(VALUES('Table'[Name]),[Measure])For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
What do we do if there are nested categories ?
Hi,
Share some data, explain the question and show the expected result. Share data in a format that can be pasted in an MS Excel file.
