Forum Discussion
joshua1990
Post Prodigy
Post ProdigyDIVIDE for just for specific codes
I have a dimensional table that shows me for each product the product group: Product Product Group A1 A A2 A B1 B Then I have a sales table, that shows me the sales per Produc...
amitchandak
Super User
Super Userjoshua1990 , Use this for sales
sumx(summarize(table, Table[Department], Table[Product], "_1", sum(Table[sales]), "_2", sum(Table[budget])), if(isblank([_2]), Blank(), [_1]))
or use this using isinscope or hasonevalue in GT