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

[Ben_Alonso]

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

[Ben_Alonso]

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

[v-yuta-msft]

@Ben_Alonso ,

---

@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 · Accepted solution]

Hi @v-yuta-msft 

 I already got it!

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"))