Forum Discussion

quickbi's avatar
quickbi
Helper II
2 years ago
Solved

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

 

 

Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    2 years ago

    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.

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    2 years ago

    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.