How to repeat the first row

[Vick143]

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 on the page so It needs to filter those.

[Vick143]

Than you very much Amit.

[daXtreme]

Hi there, @Vick143 

Since you are a new member, I'd strongly and kindly suggest that before you post anything on the forum you read this first: How to Get Your Question Answered Quickly - Microsoft Power BI Community

[amitchandak · Accepted solution]

@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