Forum Discussion
Identify System Approved data point based on client ID
Hi Experts See table below I am trying to identify all data points in my FACT Table where we have clients that have the same ID and have Status as Authorised and System Apporved, so ID 1 has Sta...
Hi Anonymous
You can created calculated column with the DAX :Has_Authorised =IF ('Table'[Status] = "System Approved",IF (COUNTROWS (FILTER ('Table','Table'[ID] = EARLIER('Table'[ID]) &&'Table'[Status] = "Authorised")) > 0,1,0),0)PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Excellent, many thanks
Happy to help🎀