Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

dax expression not working - Purchase Order Value

Hi, Can someone please suggest  Data model  Projects (project_id) = Contract(Project_id) one to many Contract(contract_id)= Contract_LineItem(contract_id) one to many both Contract(contract_id)=...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    I do not know why that is happening but the figure in the visual seems correct.  In the Table view, i filtered the ContractCustomField table on TRUE (ISACTIVE) and 1 (ProjectID).  When i export that table to Excel, i get the same answer as shown in the visual.

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
1 year ago

Hi ,

 

I found the reason -which I am having duplicate
Contract(contract_id)= Contract_LineItem(contract_id) one to many both

Contract 500011 is having three Line items in table Contract_LineItem with WBS Code 1131.

I only require one line

i.e 

But when the TOTAL is calculating its having three lines - and thus the TOTAL is different i.e 4,377,206.28.

while export to excel its giving the correct result. But the visual is showing wrong.
Any suggestion, how to handle this