Forum Discussion
lovishsood1
Resolver I
2 years agoMeasure not working in Fabric
Hello Everyone,
I have created a WAREHOUSE where I created a Measure ;
I have copied this Measure from Power BI Desktop to Fabric Data Warehouse
WAREHOUSE :
Measure :
Current Employees = CALCULATE(COUNTX(FILTER(Emp_Personal_Data,Emp_Personal_Data[tm_dateofjoining]<=max(HRMS_DateTable[Date]) && (ISBLANK(Emp_Personal_Data[tm_dateofrelease]) || Emp_Personal_Data[tm_dateofrelease] > max(HRMS_DateTable[Date]))),(Emp_Personal_Data[Full Name])),CROSSFILTER(Emp_Personal_Data[tm_dateofjoining],HRMS_DateTable[Date],None))
I created Report from the same Warehouse (Button next to New Measure) :
I used this measure in my report , It worked.
But Next Day I'm getting this error:
This is coming after a few hours.
I'm not able to get where is the error.
Error in Measure or somewhere else?
Thanks
2 Replies
- lbendlin
Super User
Are you sure you created a measure? From the error message it sounds more like a calculated column.
- lovishsood1
Resolver I
I can't find the option of creating a Calculated Column from Lakehouse.
I have attached the screenshot from where I have created the Measure as well.