Calculate current month amount if no selection on month list box

[Narender]

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

[v-frfei-msft · Accepted solution]

Hi @Narender,

Here I made an sample for your reference.

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

[Narender]

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

[v-frfei-msft]

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

[Narender]

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

[v-frfei-msft]

Hi @Narender,

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

Regards,

Frank

[Anonymous]

Hi @Narender

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.