Skip to main content

Power BI

Needs Votes

ISALL or ISTOTAL DAX Function

Vote (26) Share
Gregory J. Deckler's profile image

Gregory J. Deckler on 11 Dec 2018 04:32:11

There needs to be an "ISALL" or "ISTOTAL" DAX function that would return TRUE if the DAX is being calculated in a total row of a matrix or table visualization, for example, and FALSE otherwise. This would make creating measure totals far easier than using HASONEVALUE OR ISINSCOPE where you need to specify individual columns. This is very important for self-service BI in order to protect users that are not aware of the quirks of DAX measure totals.

Comments (2)
Gregory J. Deckler's profile image Profile Picture

Kenneth Barber on 06 Jul 2020 00:00:46

RE: ISALL or ISTOTAL DAX Function

When would this be used? What DAX code would it replace?

Gregory J. Deckler's profile image Profile Picture

Vicky M on 05 Jul 2020 23:36:56

RE: ISALL or ISTOTAL DAX Function

With Power BI's heavy focus on Self Service BI capabilities, I think this is very necessary, so that we can adapt to a model where data model designers can create measures such that users can fully rely on those to use the accurate totals without worrying about what fields they are using in rows/columns of the matrix table.