Forum Discussion

Vick143's avatar
Vick143
Frequent Visitor
3 years ago
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 on the page so It needs to filter those.

  • amitchandak's avatar
    amitchandak
    3 years ago

    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

3 Replies