cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Percentage from first row

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

1 ACCEPTED SOLUTION
Super User

@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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

2 REPLIES 2
Super User

@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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helper I

Thank you @AllisonKennedy  it works!!!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.