Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hey @nexus2004 ,
showing individual payments is only possible if you have something that sets the payments apart, like a payment id.
Regards,
Tom
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.
Hi @nexus2004 ,
If we answered your question, please mark a post as solution, this will also help others.
Please give Kudos for support.
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
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.
Hey @nexus2004 ,
showing individual payments is only possible if you have something that sets the payments apart, like a payment id.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |