topic Re: Sum and Average Columns and Rows (Not counting NA's) in DAX Commands and Tips

Sum and Average Columns and Rows (Not counting NA's)

Whitewater100 — Thu, 27 Jul 2023 18:14:53 GMT

Hello:

I am looking to average certain columns avoiding NA's. I have created a PBI file that has a table with mock data and the results I am hoping to achieve is pasted as an image on the first page. One issues is trying not to mix numeric values and texts. Any help on how to do this is very much appreciated! PBI attached.
https://drive.google.com/file/d/1GOLjgD8nmiLQ4ga8ynRQYaQx-5goNqm3/view?usp=drive_link

Re: Sum and Average Columns and Rows (Not counting NA's)

Anonymous — Tue, 01 Aug 2023 02:08:45 GMT

Hi Whitewater100 ,

I can't download your pbix file, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.