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