Forum Discussion
SudharsanRaja
1 year agoNew Member
Composite Key Error & Top Values
USECASE: I created parameter for product, country and segment. * When I clicked the product, it has to display profit greater than 180. And top 2 sales in descending order. * When I clicked the Co...
SudharsanRaja
1 year agoNew Member
Thanks MFelix . Composite key error is resolved! Rank function is executing first and then it is filtering the profit value greater than 180. But in my case it needs to execute in reverse order! Do you have any suggestions?
MFelix
1 year agoSuper User
How are you doing the filtering for the 180? In the syntax you present there is no filter on the dax measures.
- SudharsanRaja1 year agoNew Member
In dax measure I am not creating any filtering for 180. In visual filter I am using profit greater than 180!