Forum Discussion
Display Values in same Column and Aggregate dynamically
Hi Anonymous
I don't know how to calcuate the "Cancellations" value.
So I make a test as "Cancellations" is 5 by default.
1.could you create a column in your table to define "Cancellations"=5? if not, please let me know.
If you could, go on->
2.create a column of the count of product id, if you have problem doing this, let me know.
3.create columns
remain = [count_product]-[cancellations]
sub = SUM(DimProducts[cancellations])
name = "Cancellations"4.finally create a new table
Table 2 = UNION ( SUMMARIZE ( DimProducts, DimProducts[Accounting], DimProducts[remain] ), SUMMARIZE ( DimProducts, DimProducts[name], DimProducts[sub] ) )If my formula doesn't work for your scenario, please share sone example datasets for me to test.
“
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
“
Best regards,
Maggie
Community ChampionCan you post a better representation of your source data? I'm not sure how your tables are related to one another. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Based on the current table structure there is no way to bring in the the SUM of CancellationReasons and add it as a row to the AccountingClass column.
Ideally if I can bring in the Cancellation Reasons as it's own row with the sum of cancellations. As well, in the same table the COUNT to reflect dynamically the returns.