Forum Discussion

jhonKy0t's avatar
jhonKy0t
Regular Visitor
2 years ago

SQL Management Studio output is not the same with Power BI Visual Table.

I have a query that runs like this:     SELECT H.TKT_DAT, L.ITEM_NO FROM VI_PS_DOC_HDR H JOIN VI_PS_DOC_LIN L ON H.DOC_ID = L.DOC_ID JOIN PO_VEND P ON L.ITEM_VEND_NO = P.VEND_NO WHERE H.TKT_T...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

jhonKy0t , Try a measure like this

Calculate( Countrows(Summarize(VI_PS_DOC_LIN , VI_PS_DOC_HDR [TKT_DAT], VI_PS_DOC_LIN[ITEM_NO])), filter(VI_PS_DOC_HDR , [TKT_TYP] = "T" && [DOC_TYP] = "T" && [DEP_ONLY_TKT]="N"), filter(VI_PS_DOC_LIN, VI_PS_DOC_LIN[LIN_TYP] in {"S", "R"}))

 

Assuming line table is on many side