Forum Discussion
ALLEXCEPT Not Working - should i use something else?
Hi,
Create a Calendar Table and to your slicer/filter/visual, drag Date from the Calendar Table. Create a relationship (many to one and single) from the Disbursement date to the Date column of the Calendar Table. Write this measure
test fixed loan count = CALCULATE(SUM(Query1[LoanCount]),ALLEXCEPT(Calendar))
Hi,
Create a Calendar Table and to your slicer/filter/visual, drag Date from the Calendar Table. Create a relationship (many to one and single) from the Disbursement date to the Date column of the Calendar Table. Write this measure
i created this calc:
the calendar table looks like this:
and i am using a slicer now that uses the calendar date. However the same issue still exists - i.e. when i select a branch on the slicer, it changes the value.
😞
Also, why is a calendar table necessary? I appreciate the help!! Spent hours on this already...
Share the download link of the PBI file.
IT WORKED!!
That was exactly what i needed to do, thank you so much!!
The error i made was putting the wrong table name in the query...your suggestion was perfect.
THANKS SO MUCH!!You are welcome.