Converting a column into an expression

[nexus2004]

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

[TomMartens · Accepted solution]

Hey @nexus2004 ,

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

Regards,

Tom

[mwegener]

Hi @nexus2004 ,

If we answered your question, please mark a post as solution, this will also help others.
Please give Kudos for support.

[amitchandak]

When you use a table, you can show it without Aggregation. Otherwise, you can create a text column on top of it. 

like

Value = "$" + value

This can be now used as group by

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[nexus2004]

Thanks for following up.

I could drag the column and it would work fine in the table, but this column would have to be converted into a measure format. I haven't been able to find and aggregator that I can use without summing payments by customer.  I would need their individual payments to show per customer. 

I am not sure if I follow about the text column. Could you eloborate for me?

Thanks,

[mwegener · Accepted solution]

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.

[TomMartens · Accepted solution]

Hey @nexus2004 ,

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

Regards,

Tom