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

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.