cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Resolver I

## Calculate current month amount if no selection on month list box

Hi All,

I have a requirement , I want to calculate current month amount of current year.But when i will select other month(not current month) from List Box filter then report should show that month amount.

So I want a variable base amount . bydefault report will show current month amount but when some other month select than other month amount should show in report.

Thanks

Narender

1 ACCEPTED SOLUTION
Community Support

Hi @Narender,

`Measure = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,MONTH(Table1[Date])= MONTH(TODAY()) && YEAR(Table1[Date])=YEAR(TODAY()))))`

For more details, please check the pbix as attached.

https://www.dropbox.com/s/knnly3yhl4d1as6/Calculate%20current%20month%20amount%20if%20no%20selection...

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
6 REPLIES 6
Community Support

Hi @Narender,

`Measure = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,MONTH(Table1[Date])= MONTH(TODAY()) && YEAR(Table1[Date])=YEAR(TODAY()))))`

For more details, please check the pbix as attached.

https://www.dropbox.com/s/knnly3yhl4d1as6/Calculate%20current%20month%20amount%20if%20no%20selection...

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Resolver I

Hi Frank,

Thank you. It is workig for me.

Can you please tell me 1 more thing ?

how can I apply the same with Quarter. "Calculate current Quarter amount if no selection on month list box".

Thanks,

Narender

Community Support

Hi @Narender,

Please try to use the formula.

`Measure2 = IF(ISFILTERED(Table1[Month]),CALCULATE(SUM(Table1[sales])),CALCULATE(SUM(Table1[sales]),FILTER(Table1,FORMAT(Table1[Date],"q")= FORMAT(TODAY(),"q") && YEAR(Table1[Date])=YEAR(TODAY()))))`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Resolver I

Hi Frank,

I am using below measure for quarter.But it is not showing right data.

Measure 5 = if(ISFILTERED(Dates[Month]),CALCULATE(COUNT(DOCUMENT[DOC_NO]),DOCUMENT[Flag_Doc]="A"),CALCULATE(COUNT(DOCUMENT[DOC_NO]),DOCUMENT[Flag_Doc]="A",FILTER(Dates,FORMAT(Dates[Date],"q")= FORMAT(TODAY(),"q") && Dates[Year]=YEAR(TODAY()))))

Thanks,

Narender

Community Support

Hi @Narender,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Resolver I

Could you try using this measure?

Assuming, you have a date table named Date..

Sum = IF (ISFILTERED ( 'Date'[Month] ),

CALCULATE(SUM(Table[Column])),

CALCULATE (SUM(Table[Column]), Date[Month] = MONTH(TODAY()) && Date[Year] = YEAR(TODAY()))

Let me know if this works or not.

Thanks,

Suguna.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors