Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyAverage of Two and Three Column
Hi Good day, Pls need assistance on how can i have the Overall output on my table base from average. a. If the Fab column is 0 it will average by 3 three column (JC, Fab and Mat). b. if the Fab co...
DataNinja777
Super User
Super UserHi AllanBerces
In addition to the anwer provided by Ritaf1983 , I'd like to present you another way as there are multiple ways to achive your required output. One way is convert your pivoted table to a long unpivoted table using Power Query's unpivot other column function which will supress blank rows as a default, and then you can write an averagex dax measure as shown below.
I attach an example pbix file.
Best regards,