Stairway to PowerPivot and DAX - Level 5: The DAX ISBLANK() Function

  • Bill Pearson

    Ten Centuries

    Points: 1359

    Comments posted to this topic are about the item Stairway to PowerPivot and DAX - Level 5: The DAX ISBLANK() Function

  • Eric M Flamm

    SSChasing Mays

    Points: 631

    The measure example does NOT meet the specified customer requirement - that the ratio cell where Internet Promo sales are blank should read "NA" rather than blank. This in turn causes an issue with the Calculated Measure, since it contains text data and can not be formatted as a % as specified.

    I'm also not sure that "ISBLANK(sum(...SalesAmount))" makes sense - it implies that the Sum of 1 or more BLANKs is BLANK, and I'm not sure that's actually part of the spec (although it does seem to work!).

    [font="Tahoma"]Eric Flamm, Flamm Consulting[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply