Forum Discussion
Calculated Table: Summarize + 1 row
Hi,
I created a calculated table using SUMMARIZE. However, I would like to add 1 additional row with just the text "Not Specified".
--> SUMMARIZE produces 1 column, I would just like to supplement it with an additional row. Can this be done?
3 Replies
CarlsBerg999 , Union(Summarize() , Row() )
example
ROW("ProductCode_wOthers", 99, "Item_wOthers", "Others"),
Hi, is it possible to feed ROW() with a manual value? The code DAX seems a bit complicated for just adding "Not Specified", although it works:
ROW("Not Specified",LOOKUPVALUE('Revenue'[Program],'Revenue'[Program],"Not Specified")))CarlsBerg999 , Row is for static values. In case you need to get values from a table, use another summarize, selectcolumns etc
Refer this too -https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
