Choose a single record table

[azakir]

Hi Guys. 

Wanted to see if anyone can help out with this. 

I've got a table visual that has document versions. As document has different versions on different dates, it shows up more than once. I am trying to do 2 things here: 

1) If MAX PG version is same as TG version, Show "inherited", else "non inherited"

2) show just one record per document version. So comparing MAX of PG Version with MAX of TG Version: 

[devesh_gupta · Accepted solution]

@azakir To show just one record per document version, you can use the following DAX formula:

Table = SUMMARIZE (
    'Table Visual',
    'Table Visual'[Document Version],
    "Max PG Version", MAX ( 'Table Visual'[PG Version] ),
    "Max TG Version", MAX ( 'Table Visual'[TG Version] )
)

To show “inherited” if the maximum PG Version is the same as the maximum TG Version, and “non inherited” otherwise, you can use the following DAX formula:

Inheritance = IF (
    [Max PG Version] = [Max TG Version],
    "inherited",
    "non inherited"
)

If you find this insightful, please provide a Kudo and accept this as a solution.

[devesh_gupta · Accepted solution]

@azakir To show just one record per document version, you can use the following DAX formula:

Table = SUMMARIZE (
    'Table Visual',
    'Table Visual'[Document Version],
    "Max PG Version", MAX ( 'Table Visual'[PG Version] ),
    "Max TG Version", MAX ( 'Table Visual'[TG Version] )
)

To show “inherited” if the maximum PG Version is the same as the maximum TG Version, and “non inherited” otherwise, you can use the following DAX formula:

Inheritance = IF (
    [Max PG Version] = [Max TG Version],
    "inherited",
    "non inherited"
)

If you find this insightful, please provide a Kudo and accept this as a solution.

[azakir · Accepted solution]

Thanks @devesh_gupta That did the trick for me.