Why Filter context does not apply ??

[Arnaud81]

Hi all,

I'm sure that one of you can help me

I have a pivot table :

Columns : Year and Quarters
Rows : Customers Beginning of Qtr & Customers End of Qtr

Measures :

BOQ:=CALCULATE([EOQ]; PREVIOUSQUARTER(Calendar[FullDate]))
EOQ:=DISTINCTCOUNT ( Sales[Customer name] )

Everythings works perfectly fine until I add a slicer with Months and make a selection to have QTD info
Suddenly BOQ & EOQ are not right anymore

Thank you for your help

Arnaud

 

[akice]

How is it "not right"? If you select a month, then EOQ will simply calculate the number of distinct Sales[Customer name] visible in current context.

BOQ will calculate the number of distinct Sales[Customer name] for the entire previous quarter. (PREVIOUSQUARTER function returns all dates from the previous quarter, using the first date visible in the current filter context as reference for what current quarter is). Is this what you intended?

 

[Arnaud81]

Well, EOQ behavior is exactly how I expected.
But with BOQ I was expecting that depending my selection of months (ex : JAN, FEB, APR, MAY, JUL, AUG,...) it would change the number of customers comparing to a full previous Qtr.
But giving your explanation about Previousquarter function then I understand better this behavior.
How should I change my measure to display the information I want ?

Thanks a lot !

Arnaud

 

[akice]

I am not clear on what you want to select with slicers and what results you are wanting. Can you give an example?

 

[Arnaud81]

What I would like to achieve is to have a pivot table with different kind of measures.
One of them being "Nb of customers at the beginning of the Quarter" which is in fact the same number than "Nb of customers at the end of the Quarter" for the previous Quarter.
I have a problem with "Nb of customers at the beginning of the Quarter" when I use a slicer "month" to simulate a QTD situation (Selecting only the 2 first months of each quarters for example) --> the 2 measures give different numbers. If I clear the slicer then the 2 measures give the same numbers (expected result).