Hi All
i have encountered a very strange issue
i have a measure that looks like
Lines_Total_Sales = CALCULATE(CALCULATE(SUM('Global VJT_Lines'[Calc_Value]),'Global VJT_Lines'[Group]="Sales",'Global VJT_Lines'[Internal]="False",'Global VJT_Lines'[Value Type]="$"),
EXCEPT(VALUES('Global VJT_Lines'[LineFactory To]),CALCULATETABLE(SUMMARIZE('Global VJT_Lines','Global VJT_Lines'[Line Factory From]),ALLSELECTED())))
it is working perfectly in the power bi desktop (the data base is currently SQL server)
but when i upload to the service the measure show blank (after the refresh)
in the past the data souece was ODBC and then there was no problem in the service.
i will appriciate any ideas
many thanks