cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

2 ACCEPTED SOLUTIONS

Hey @nexus2004 ,

 

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

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

View solution in original post

5 REPLIES 5
Super User II
Super User II

Hi @nexus2004 ,


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

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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,

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

View solution in original post

Hey @nexus2004 ,

 

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

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors