Forum Discussion

axiosfabric's avatar
axiosfabric
New Member
2 years ago

Dynamic column generation using DAX

PROFSUMMARY = SUMMARIZE ( Hi, Training, Training[ID], Training[Prof], "DP101", CALCULATE ( SUM ( Training[Att Hrs] ), Training[Code] = "DP101",Training[Mode] = "Virtual" ), "DP103", CALCULATE ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi axiosfabric 
Source data

Taking a Matrix Visualization and turning off column/row subtotals

 

if this solves your problem then please accept the same as your solution.