Correct total calculation when using a filitered measure (SUMX)

[Anonymous]

Hello all,

i have an issue showing the correct total, consequence of my filtered measure. The correct ammount should be 156,730. I figure this could be solved using isfiltered  or hasonevalue but im not pretty familiar with this function, i would appreciate a tip on how to workaround this.

i am using the calendar to see if the values are filtered or not 

hasonevalue = (HASONEVALUE(CalendarTable[Fiscal Year])).

i am using the calendar to see if the values are filtered or not 

hasonevalue = (HASONEVALUE(CalendarTable[Fiscal Year])).

The SUMIFEH function is the one filtering the values 

 

 very grateful for the help

Miguel

[Anonymous · Accepted solution]

I got this solution to work

hasonevalue = IF(HASONEVALUE(CalendarTable[Fiscal Year]),[SUMIFEH_2],SUMX(VALUES(CalendarTable[Fiscal Year]),[SUMIFEH_2]))

[amitchandak]

@Anonymous , Change return like sumx(Values(Table[Fiscal Year]), P)

[Anonymous]

Thank you for the help 

unfortuneately not working still giving me a wrong value i tried using the calendar table fiscal year and the built and normal calendar