Forum Discussion
How to Create Aggregated table from fact table
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.
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] )))
2 Replies
- amitchandak
Super User
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] )))