How to Create Aggregated table from fact table

[Anonymous]

hi all,

i am new to Power BI. learned few tips and tricks and trying myself. can you help to support on how to create aggregate table for using in the report. below screen is sample. i have more dimensions. so, I am looking for DAX expression on this. kindly support on this.

[amitchandak · Accepted solution]

@Anonymous , a new table in DAX like

summarize(Table, Table[company], Table[LOB] , Table[Lcurr] , "Deduction",calculate(sum(Table[Deduction]), Table[Type] = "YU")
, "value",calculate(sum(Table[value]), Table[Type] = "YU")
, "Gcurr", calculate(max(Table[Gcurr]), not(isblank(Table[Gcurr] )))
"Deduction1" ,calculate(sum(Table[Deduction]), isblank(Table[Type] ))
, "value1",calculate(sum(Table[value]), isblank(Table[Type] )))

[Anonymous]

Hi Amit,

Really appreciate your support on this. it's working for SGD.

but, my numbers not correct for EUR. in my earlier screen I entered the type in the wrong cell.