Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
4 years ago

Need help with Dax

Hi,
I'm facing the issue with dax, 
I wrote a measure that giving last order date respective of particular tag id. 
meanwhile using order id from the tag table, its returning all the order id's. But actually it should return only one Order ID, which would be the last order date based on my measure.

Max OrderDate = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID]),'Tag Usage Fact'[Date DD/MM/YYYY]).
similarly when there are different order owners the date records repeat for every different order owner. Bit it should be ideally showing just one record. 

 
also this is whah happens when we show account name from account table
Actually my result should be as shown below but including the above 3 mentioned columns.
 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Can you please share the sample data with the output that you are expecting.