Power BI doesn't summarize data for me

[PBIUser_mh]

Hi there, 

I am quite new to Power BI and have been working on it for a moment.

I have some problems today.

As you can see, I wrote some conditions here using SWITCH().

But when I visualized data, I got this.

I have no idea why there are 2 "Expired" rows here. It's been the same with Table, Matrix and even Pie chart.

I have used SWITCH() a lot but never got this kind of confusing outcome before.

I tried refreshing the dataset. closing and reopening the file multiple times but it remains the same.

Could anyone explain why it happened?

Thank you!

[PBIUser_mh · Accepted solution]

Well, the issue has been solved. I just created a new calculated column with the same DAX code, visualized again and this time it worked fine.

Maybe Power BI went crazy for a while 😅

[MahyarTF]

Hi,

what is the value for '.....[3.1 Remaining time (M)]' column for particular rows, that return 'Expired' ?

Also, why do you use another switch () in the main switch() statement while you could use '=0' and '< 0' in separate lines?

[PBIUser_mh]

Hi there,

[3.1 Remaining time (M)] is the whole number calculated by DATEDIFF() and it returns the time remaining in months

The reason I put another SWITCH() in the main SWITCH() is because when [3.1 Remaining time (M)] <= 0, I need to check further on days (which is [3.11 Remaining time (D)])  remaining too.