topic Re: How to repeat the first row in DAX Commands and Tips

How to repeat the first row

Vick143 — Fri, 28 Oct 2022 17:42:17 GMT

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 — Sat, 29 Oct 2022 03:18:04 GMT

Vick143 , If you need like sub total. You use removefilters, allexcept

example

calculate([Commission], removefilters(Table[level 2 column]))

calculate([Commission], all(Table[reporting column]))

calculate([Commission], allexcept(Table, Table[reporting column]))

daXtreme — Sun, 30 Oct 2022 07:55:41 GMT

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

Vick143 — Mon, 31 Oct 2022 12:52:15 GMT

Than you very much Amit.