Forum Discussion

evanderpoel's avatar
evanderpoel
Frequent Visitor
5 years ago
Solved

Place Text Values into a Matrix Table - PLEASE HELP!

I'm wondering if there is a way to put text data into a row in a matrix. I would like to add a row that shows each price that is connected to the sub-brand on each week. Some are regular prices like ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi evanderpoel ,

     

    Based on the information you shared you need to use the following syntax:

     

    MEASURE = 
IF (
    ISINSCOPE ( 'Data Master'[Week] ),
    CALCULATE (
        CONCATENATEX (
            VALUES ( 'Retail Survey'[RS Price TY] ),
            'Retail Survey'[RS Price TY],
            ","
        ),
        KEEPFILTERS ( 'Data Master' ),
        'Retail Survey'[RS Price TY] <> BLANK ()
    )
)

     

     

     

    The INSCOPE part is to remove the calculation from the total values and the keepfilters allows to keep the subbrand and week filters to get the correct prices.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi evanderpoel ,

 

Based on the information you shared you need to use the following syntax:

 

MEASURE = 
IF (
    ISINSCOPE ( 'Data Master'[Week] ),
    CALCULATE (
        CONCATENATEX (
            VALUES ( 'Retail Survey'[RS Price TY] ),
            'Retail Survey'[RS Price TY],
            ","
        ),
        KEEPFILTERS ( 'Data Master' ),
        'Retail Survey'[RS Price TY] <> BLANK ()
    )
)

 

 

 

The INSCOPE part is to remove the calculation from the total values and the keepfilters allows to keep the subbrand and week filters to get the correct prices.

evanderpoel's avatar
evanderpoel
Frequent Visitor
5 years ago

This worked great, thank you so much for your help, much appreciated!!