cancel
Showing results for
Did you mean:
Ben_Alonso Frequent Visitor

## Calculate and visualize a default rate using series within the same column

Hi all, I have a table with 3 columns (Date, Series, Value). I would like to obtain for each different date the division of 2 different Series (that will be the default rate=total default/total credit, in particular be the default rate=BE_4_29.1.1/BE_4_29.1.2). Thank you 1 ACCEPTED SOLUTION

Accepted Solutions
Ben_Alonso Frequent Visitor

## Re: Calculate and visualize a default rate using series within the same column

Just with this measure and choosing the more desagregated option for dates in the visualization (as I don't really want a Sum of the values which would be wrong indeed).
Thanks.

Tasa_PRUEBA = DIVIDE(CALCULATE(sum(be0429[Value]);be0429[Series]="BE_4_29.1.1");CALCULATE(sum(be0429[Value]);be0429[Series]="BE_4_29.1.2")) 3 REPLIES 3
Ben_Alonso Frequent Visitor

## Re: Calculate and visualize a default rate using series within the same column

Hi, just to clarify it...

I have a table with 3 columns (Date, Series, Value). I would like to obtain for each different Date the division of 2 Series  (the series included are always the same in particular default rate=BE_4_29.1.1/BE_4_29.1.2 so the value for each date is the default rate for it as the values of the 2 Series correspond to that date). Thank you Community Support Team

## Re: Calculate and visualize a default rate using series within the same column

@Ben_Alonso wrote:

Hi, just to clarify it...

I have a table with 3 columns (Date, Series, Value). I would like to obtain for each different Date the division of 2 Series  (the series included are always the same in particular default rate=BE_4_29.1.1/BE_4_29.1.2 so the value for each date is the default rate for it as the values of the 2 Series correspond to that date). Thank you

Could you show the expected result? (e.g.: each different date the division of Series)

Regards,

Jimmy Tao

Ben_Alonso Frequent Visitor

## Re: Calculate and visualize a default rate using series within the same column

Just with this measure and choosing the more desagregated option for dates in the visualization (as I don't really want a Sum of the values which would be wrong indeed).
Thanks.

Tasa_PRUEBA = DIVIDE(CALCULATE(sum(be0429[Value]);be0429[Series]="BE_4_29.1.1");CALCULATE(sum(be0429[Value]);be0429[Series]="BE_4_29.1.2")) Announcements #### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest! #### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system. #### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge. #### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests! #### Power Platform Online Conference 