Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple dates within 1 dataset

Hi guys,   I have a dataset that looks like this:    Policy Number Policy Start Date Cancellation Date 123 01/01/2019 05/05/2019 234 02/02/2019 06/06/2019 345 03/03/2019 06/06...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Use ALL(Table) instead of ALL(Table[Column]) as below:

    Cancellation Rate = DIVIDE ( SUM ( [Cancelled] ) , CALCULATE ( COUNT ( 'Table'[Policy Number] ) , ALL ( 'Table') ))

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

Use ALL(Table) instead of ALL(Table[Column]) as below:

Cancellation Rate = DIVIDE ( SUM ( [Cancelled] ) , CALCULATE ( COUNT ( 'Table'[Policy Number] ) , ALL ( 'Table') ))

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.