Forum Discussion

Vikki's avatar
Vikki
Frequent Visitor
4 years ago

Calculate Max value in a table visual

Hi Everyone,   I am trying to write a DAX measure to calculate Max value in a table visual. Please refer to the image below: I created a 3-column table visual, column 1 and 3 are dragged fro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Vikki ,

Is there any relationship created between table AD and All Entries? Could you please provide some sample data in table All Entries? From your screenshot, it looks like there are multiple dates for each branch, do you want the final result to get the [% on Site] of the latest date for each branch? For example, Branch: USS only shows Date Sep 17, will the final result be what is circled in red in the table below?

Expected result??

Best Regards

Vikki's avatar
Vikki
Frequent Visitor
4 years ago

Hi Anonymous amitchandak ,

 

Thank you for looking into this. 

One of the other problem I am facing is there is many to many relationship between AD table and All Entries table, through people's names, which is not a reliable key. But for now, the client didn't provide anything else.

I wonder if this is not acheivable unless I have a unique key and 1 to many relationship between AD and All Entries table.

Thanks anyway,

Vikki