Forum Discussion

carloscabreraq's avatar
7 years ago
Solved

Different row data Type in Matrix

Hello, how can i get different row data type in a Matrix.   For example Measure MTD, row A = integer, B percentage and C =  numeric with 2 decimals.     Thanks for your help
  • v-lili6-msft's avatar
    7 years ago

    HI, carloscabreraq

    After my test, you could try this way as below:

    Use FORMAT Function with IF/ SWITCH in your formula of measure.

    For example:

    Measure = 
    VAR _A =
        CALCULATE ( SUM ( 'Table'[Qty] ), FILTER ( 'Table', 'Table'[Type] = "MTD" ) )
    RETURN
        IF (
            SELECTEDVALUE ( 'Table'[ID] ) = "A",
            FORMAT ( _A, "0" ),
            IF (
                SELECTEDVALUE ( 'Table'[ID] ) = "B",
                FORMAT ( _A, "0.0%" ),
                IF ( SELECTEDVALUE ( 'Table'[ID] ) = "C", FORMAT ( _A, "0.00" ) )
            )
        )
    Measure 2 = VAR _A =
        CALCULATE ( SUM ( 'Table'[Qty] ), FILTER ( 'Table', 'Table'[Type] = "LMTD" ) )
    RETURN
        IF (
            SELECTEDVALUE ( 'Table'[ID] ) = "A",
            FORMAT ( _A, "0" ),
            IF (
                SELECTEDVALUE ( 'Table'[ID] ) = "B",
                FORMAT ( _A, "0%" ),
                IF ( SELECTEDVALUE ( 'Table'[ID] ) = "C", FORMAT ( _A, "0.00" ) )
            )
        )

    By the way, for B percentage, FORMAT ( _A, "0.0%" ) and FORMAT ( _A, "0%" ) is used for decimals.

    Result:

    and here is the document for you refer to

    https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function

     

    Best Regards,

    Lin