When selecting max value data not getting filtered properly as per other relationships

Question

Planid&nbsp; &nbsp;Datekey&nbsp; &nbsp; HOurs&nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Planid&nbsp; Region1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201601&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;America2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201601&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp;Europe1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201601&nbsp; &nbsp; &nbsp;15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp;Asia3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201601&nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50When Iam using simple matrix&nbsp; 2016&nbsp; 50, but plan is not filtering it, can someone help, (I have selected max of hour in my matrix)

parry2k · Answer

Anonymous it is not clear what you are asking here. Read this post to get your answer quickly
&nbsp;
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;
&nbsp;

anonymous · Answer

when i am selecting matrix for the above table&nbsp;Filter: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Filter:All &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; America&nbsp;2016 &nbsp; 50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016 &nbsp; 20&nbsp;How to achieve the 2nd result with my exisitng tables?

parry2k · Answer

Anonymous did you read the blog post on how to get answer quickly. Without knowing what your dataset is, it is very hard to answer your question.

Forum Discussion

When selecting max value data not getting filtered properly as per other relationships

3 Replies

Related content

Relationship

Relationships

Relationship Issue - Keep Filter ISsues.

Relationship Issue

Creating relationships