cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Allexcept and slicer

Hello, guys!

I think the solution is not  difficult, but I still can't find it. Could you help me?

The task  - find measure average by filtered date perion in pivot table by each objects (object - rows, month - columns).

For this, i use such formula:

test = CALCULATE ( measure, ALLEXCEPT ( 'Calendar', 'Calendar'[Year] ))


and it works fine, till i have to use month slicer to change full year to 10 month, for example.

 

The "test" still calculate the whole year average.
How could I avoid it? And get dynamic average, depends on choosing months?

 

Lind to db: https://gofile.io/d/VLBPTf

 

How it should be (11 months):

Avg sales between dates
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
19 REPLIES 19
Highlighted
Highlighted

@VijayP  

no, sir, it doesn`t (

 

if works well when u choose all months

first.PNG

 

but it doesn`t , when u use date filter:

 

second.PNG

Highlighted

@KonstantinD 

Its working for me.

VijayP_0-1600955600381.png

 

Highlighted

@KonstantinD 

I thinks this is the approach. 

VijayP_0-1600956339681.png

 

Highlighted

final.PNGthats what iam talking about @VijayP 

Highlighted

@KonstantinD 

Will this Do?

VijayP_0-1600957450246.png

 

Highlighted

@VijayP  looks similar.

could u please share the pbix ? 

Highlighted
Highlighted

@VijayP  thank you so much!

its work!

Highlighted

@KonstantinD 

Please share your Kudoes, Many if possible hahahahah 😂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors