Forum Discussion

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
2 years ago

Measure 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

  • Are you sure you created a measure?  From the error message it sounds more like a calculated column.

    • lovishsood1's avatar
      lovishsood1
      Icon for Resolver I rankResolver 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.