Percentage from first row

[quickbi]

Hi, 

I have a table like this, with date in rows, index in columns and count(customer_id) in values.
the result is this one:

But I want to know the percentage of each index versus the first one. For example in february 2023 we got in second index 8022 users versus 36313 and the result should be 22,1%
I have no idea how to do that
Thanks

[AllisonKennedy · Accepted solution]

@quickbi  if you're wanting index 1 as your baseline to always compare to, make a measure that always shows index 1, no matter what index is in filter context:

[Customer Count - Index 1] = 
CALCULATE ( Count(Table[Customer_id]) , Table[Index] = 1)

Then you can create a measure to calculate the %:

[Customer Count - % of Index 1] = 
DIVIDE( Count(Table[Customer_id]), [Customer Count - Index 1] )

and format that as a percent.

[quickbi]

Thank you @AllisonKennedy  it works!!!!