DAX error

[Sonalim]

calculate(COUNTX(TBL_DTL_PURC_REQUISITIONS,TBL_DTL_PURC_REQUISITIONS[Requisition_Code]), filter( TBL_DTL_PURC_REQUISITIONS,TBL_DTL_PURC_REQUISITIONS[Requisition_ID] in (SUMMARIZE('TBL_DTL_PURC_REQUISITIONS','TBL_DTL_PURC_REQUISITIONS'[Requisition_Code],"Ct_Req",max('TBL_DTL_PURC_REQUISITIONS'[Requisition_ID]))) && TBL_DTL_PURC_REQUISITIONS[Doc_Type] =87))

I am using this measure for caculation of count requisition code where i have to grp by the table with requisition code an dthen tofind maximum rqstn -id wrt to rqstn-code and after then filter condition like do-type 87 

But getting with the same dax,

Confused how to do this 

can any body help ?

[v-yangliu-msft · Accepted solution]

Hi  @Sonalim ,

You can try the following dax:

Measure =
var _maxID=
MAXX(
    ALL('Table'),'Table'[Requisition_ID])
RETURN
COUNTX(
    FILTER(ALL('Table'),
    'Table'[Requisition_ID]=_maxID&&'Table'[Doc_Type]=87),[Requisition_Code])

If it doesn't meet your expected results, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Re: How to Get Your Question Answered Quickly - Page 5 - Microsoft Fabric Community