Forum Discussion
Solved
Dynamic Grouping via Support table
Hi Guys, Hope you all had anice weekend. I am currently learning how to make dynamic grouping via support table. Customer Sales by Group = CALCULATE( [Total Sales], FILTER( VALUES( Cus...
HI Dankang,
#1. It is used to ignore result who not suitable for your conditions.(count row with blank table will blank result, power bi will recognize it as zero)
#2. All function is used to break filter effect to let formula calculated on whole table.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng
HI Dankang,
#1. It is used to ignore result who not suitable for your conditions.(count row with blank table will blank result, power bi will recognize it as zero)
#2. All function is used to break filter effect to let formula calculated on whole table.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng