Value for current Fiscal Month regardless the filter

[joshua1990]

Hello everyone!

I have a matrix with different measures.

In total there are 5 measures. 4 measures based on the current fiscal week. For this purpose I have a filter on this visual with the current month (TRUE/ FALSE). The last measure should sum up all values for the current MONTH.

But how is this possible, since I have a filter for the current week for the visual?

The measure is something like SUM ( Sales[Sales]).

I allready have the current month column in the calendar. Our fiscal months have specific start and end dates - if this is a useful information.

Best Regards

[Anonymous · Accepted solution]

// Assumptions:
// You've got a stand-alone Calendar table
// that is a date table marked as such
// in the model. [Base Measure] is the
// measure you want to calculate over
// the current month. 'Calendar'[Current Month]
// is a TRUE/FALSE field in Calendar
// marking with TRUE the days that belong to
// the current (fiscal?) month.

[Base Measure for Current Month] =
CALCULATE(
    [Base Measure],
    'Calendar'[Current Month],
    ALL( 'Calendar' )
)

[harshnathani]

Hi @joshua1990 ,

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Can you share some sample data or screenshots of your visualization.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)