Skip to main content
Microsoft Idea

    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 (3)
    Gregory J. Deckler's profile image Profile Picture

    Andreu fil on 19 Apr 2024 18:45:09

    RE: ISALL or ISTOTAL DAX Function

    Good information, thankssehackear.top

    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.