Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I calculate averages in my table and also I want a Total average from those averages.
But sometime I have no value, then then total average must give the total average from the other averages without the blank.
Below is an example where you see an Total average of 1.6 (8+0+0+0+0/5 = 1.6).
But I want this Total number to be 8 (8+0+0+0+0/1).
What to do?
Thanks
Hi @pvravestein
You can follow the below approach as well:
Unvpivot your columns in Power Query or you can create new table using the below dax.
@pvravestein , Try like
averagex(filter(Table, Table[Col1]<> 0 && not(isblank(Table[Col1]))),[Table[Col1]])
Great, thanks. But forgive me, I am new to DAX and I cannot get it to work.
My table name is change, column names are on top of my screenshot. What will it look like with all data?
Many thanks
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |