Forum Discussion
Solved
How to repeat the first row
Hi, I need a help creating a measure. the outcome must look like column Pagged Commision V_3 from the image below. All I need is the Reporting Level row numbers to reapeat. I have filters/slicer o...
Vick143 , If you need like sub total. You use removefilters, allexcept
example
calculate([Commission], removefilters(Table[level 2 column]))
or
calculate([Commission], all(Table[reporting column]))
calculate([Commission], allexcept(Table, Table[reporting column]))
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
Than you very much Amit.