Forum Discussion

mpicca13's avatar
mpicca13
Icon for Resolver IV rankResolver IV
5 years ago
Solved

Displaying Multiple Currency Types in a Matrix

I've been having a very difficult time with this problem and hoping someone can shed some light my way. I have matrix which shows ProductNames by Row, Websites they are sold on by Column and the MAX...
Need Help
  • mpicca13's avatar
    mpicca13
    5 years ago

    Figured out the performance issue. Kind of embarrased it was so simple:

    The original concatenate formula i mentioned in the first reply was concatenating every cell, even blanks which resulted in ppor performance.

    adjusting the formula to the following gave me my intended results with good performance:

    IF (
        NOT ( ISBLANK ( [MAX Price] ) ),
        CONCATENATE (
            MAX ( 'fact table'[Currency] ) & " ",
            ROUND ( [Max Price], 2 )
        ),
        BLANK ()
    )

mpicca13's avatar
mpicca13
Icon for Resolver IV rankResolver IV
5 years ago

Figured out the performance issue. Kind of embarrased it was so simple:

The original concatenate formula i mentioned in the first reply was concatenating every cell, even blanks which resulted in ppor performance.

adjusting the formula to the following gave me my intended results with good performance:

IF (
    NOT ( ISBLANK ( [MAX Price] ) ),
    CONCATENATE (
        MAX ( 'fact table'[Currency] ) & " ",
        ROUND ( [Max Price], 2 )
    ),
    BLANK ()
)