Forum Discussion

nexus2004's avatar
nexus2004
Frequent Visitor
6 years ago
Solved

Converting a column into an expression

Hello All,

 

There is a column of numeric data I would like converted into an expression. This expression would then be nested into a secondary expression.

 

This column has payment data and  the "do not summarize" option selected.  In the example below, the desired result is to have the payments listed so :

 

Customers  Payments

Allen           $50

Steve           $60

Allen           $10

 

Would become:

Customers  Payments

Steve           $60

Allen           $50

Allen           $10

 

The problem is when writting  a measure, the column must have an aggregate before it, such as SUMX. This would combine Allen with $60, where I need the split of each customer and their payment. What would be the best way to convert the payment column into a measure and not consolidate the customer data? 

 

Thanks

  • Hey nexus2004 ,

     

    showing individual payments is only possible if you have something that sets the payments apart, like a payment id.

     

    Regards,

    Tom

  • mwegener's avatar
    mwegener
    6 years ago

    Hi nexus2004 ,

     

    a measure is always a kind of aggregation.

    A slicer on an axis is required to separate the values.

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

5 Replies