Forum Discussion

fcucek's avatar
fcucek
Frequent Visitor
1 year ago
Solved

Sort Parameter values in Paginated Reports (using RSCustomDaxFilter)

Hello community,    know that my questions doesn't fit 100% in this thread, but didn't know where to ask else. Please help me out with this minor thing which drives me nuts.    My customer wants ...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi fcucek ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    Please go through the below solved issue which may help you to resolve the issue.
    Solved: RSCustomDaxFilter Documentation - Microsoft Fabric Community

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
    Best Regards, 
    Menaka. 
    Community Support Team 

fcucek's avatar
fcucek
Frequent Visitor
1 year ago

Thank you all for your help. Could solve it with this query

EVALUATE
DISTINCT(
SELECTCOLUMNS(
   FILTER(Output,
        PATHCONTAINS(@OutputFIRMA, 'Output'[FIRMA])
    ), 
        "ANM2",'Output'[ANM2]))
ORDER BY [ANM2] DESC

 

And additionally I used this query for the parameter value

=Join(Parameters!Firma.Value,"|")

 

Works fine now.

Cheers,