Forum Discussion

DevDelwyn's avatar
DevDelwyn
Frequent Visitor
7 years ago

GROUPBY with ALLEXCEPT filter in measure

Is there a way to use ALLEXCEPT in filtering the input to a GROUPBY Table measure?   I am creating a dashboard to show comparitive figures between the latest report month and selected month that th...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi DevDelwyn ,

What about changing ALLEXCEPT to ALLSELETED ?

In addition, if it is convenient, could you share the dummy pbix file or function of [Latest Report Month] so that I could have a test on it?

Best  Regards,

Cherry

 

DevDelwyn's avatar
DevDelwyn
Frequent Visitor
7 years ago

Hi v-piga-msft ,

 

I cannot get ALLSELECTED to respond correctly, either it has no affect on the Latest Month Order Value Fix2 or responds with Multiple Arguments not allowed error. (...although I thought this function was for ignoring filters applied within the measure as opposed to from external slicers?)

 

[Latest Report Month] Measure is simply to get the name of the most recent month of Data.

Latest Report Month = format(CALCULATE(max('All Clients'[Canc. Date Fix]),all('All Clients')),"MMM")
I have also attached a sample copy of the .pbix file
 
As stated, the 'Latest Month Order Value 2' measure produces the correct total Month value, but this does not change when slicers select a different Cycle No. Band.