Need Help in the Calculation - If-Then_Else or alternatives

[jambopriti]

Hi,

I have the below request (testdata) is included. Please guide. Thanks.

I have these requirements and need to create the visual like below. Please guide. Thank you.

Calculate the Readmits:

• Get total number of records as the denominator
• Filter Same Level = “yes”
• Days 0-30, Count the NO. of records
• Days 31-60, Count the NO. of records
• Days 61-90, Count the NO. of records
•  
• Days 91-365, Count the NO. of records
• Divide the readmit in each category by the total no. of records. 

My result should be

• Days 0-30 – 2 readmits
• Days 31-60 – 0 readmit
• Days 61-90 – 1 readmit
• Days 91-365 – 3 readmits

Visual:

Re-Admit Data
	30 Day	60Day	90 Day	1 year
Total Readmissions	2	0	1	3
Percent Readmit	4.44%	0	2.22%	6.67%

Data:

id	service	date	same_level	Days
6790894	RC	1/22/2025	No
6803017	RC	3/3/2025	Yes	102
6783644	RC	1/19/2025	Yes	317
6811454	RC	3/15/2025	No
6815434	RC	3/26/2025	No
6813452	RC	3/10/2025	No
6810816	RC	3/21/2025	No
6806671	RC	2/21/2025	No
6805507	RC	3/7/2025	No
6802936	RC	2/26/2025	No
6798416	RC	2/25/2025	No
6791776	RC	2/2/2025	No
6782626	RC	1/11/2025	No
6781434	RC	1/10/2025	No
6803862	RC	3/5/2025	No
6789267	RC	1/21/2025	No
6826130	RC	3/30/2025	No
6814711	RC	3/20/2025	No
6801497	RC	2/22/2025	No
6798936	RC	2/25/2025	No
6795489	RC	2/5/2025	No
6794939	RC	2/13/2025	No
6780098	RC	1/10/2025	No
6784350	RC	1/22/2025	No
6810948	RC	3/17/2025	No
6797179	RC	2/24/2025	No
6797303	RC	2/24/2025	No
6804658	RC	2/28/2025	No
6804356	RC	3/1/2025	No
6800258	RC	2/27/2025	No
6808375	RC	2/17/2025	No
6799512	RC	2/26/2025	No
6806709	RC	3/16/2025	No
6797819	RC	2/19/2025	No
6821183	RC	3/26/2025	No
6798021	RC	2/23/2025	No
6797813	RC	2/19/2025	No
6788436	RC	1/29/2025	Yes	8
6788609	RC	1/29/2025	Yes	82
6798616	RC	2/15/2025	No
6792929	RC	2/2/2025	No
6792330	RC	2/10/2025	No
6816231	RC	3/10/2025	No
6816150	RC	3/28/2025	Yes	19
6791245	RC	1/30/2025	Yes	215

[jambopriti]

Thank you. I had a twik my table and column data type. it is working now. 

Thank you for your help!! I'll mark this one as solved. Thanks again.

[jambopriti]

Thanks. Need a guidance on the above. thanks.

[v-bmanikante · Accepted solution]

Hi @jambopriti ,

Thank you for reaching out to Microsoft Fabric Community Forum.

Please use the following DAX measures.

Total Records(Readmits) = COUNTROWS('ReAdmit DATA')

Readmit 0-30 =

CALCULATE(

    COUNTROWS('ReAdmit DATA'),

    'ReAdmit DATA'[same_level] = "Yes",

    'ReAdmit DATA'[Days] >= 0,

    'ReAdmit DATA'[Days] <= 30

)

Readmit 31-60 =

if(ISBLANK(CALCULATE(

    COUNTROWS('ReAdmit DATA'),

    'ReAdmit DATA'[same_level] = "Yes",

    'ReAdmit DATA'[Days] > 30,

    'ReAdmit DATA'[Days] <= 60

)),0,cALCULATE(

    COUNTROWS('ReAdmit DATA'),

    'ReAdmit DATA'[same_level] = "Yes",

    'ReAdmit DATA'[Days] > 30,

    'ReAdmit DATA'[Days] <= 60

))

Readmit 61-90 =

CALCULATE(

    COUNTROWS('ReAdmit DATA'),

    'ReAdmit DATA'[same_level] = "Yes",

    'ReAdmit DATA'[Days] > 60,

    'ReAdmit DATA'[Days] <= 90

)

Readmit 91-365 =

CALCULATE(

    COUNTROWS('ReAdmit DATA'),

    'ReAdmit DATA'[same_level] = "Yes",

    'ReAdmit DATA'[Days] > 90,

    'ReAdmit DATA'[Days] <= 365

)

Percent 0-30 = DIVIDE([Readmit 0-30], Total Records(Readmits))

Percent 31-60 = DIVIDE([Readmit 31-60], Total Records(Readmits))

Percent 61-90 = DIVIDE([Readmit 61-90], Total Records(Readmits))

Percent 91-365 = DIVIDE([Readmit 91-365], Total Records(Readmits))

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[jambopriti]

Hello, Thank you.

I'm getting the below errors. Please guide. Thanks.

[v-bmanikante]

Hello @jambopriti ,

Could you please share the sample PBIX file with us?

Additionally, kindly let us know the specific context in which you are encountering the errors. Are the errors occurring when you drag the measures onto a visual, or are they present within the measures themselves?

Your clarification will help us assist you more effectively.

Regards,

B Manikanteswara Reddy