Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

TOPN function doesn't allow me to quote a table

Hi, I try to create a topn measure to get the sum of  of top 5 KPI achievement %, however, it looks like the TOPN function doesn't allow me to quote a table. Usually after typing the ' sign (see belo...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

As tested, it works on my side.

Measure = CALCULATE(SUM([value]),TOPN(5,Table1,[value]))
or 
Measure = CALCULATE(SUM([value]),TOPN(5,'Table1',[value]))
or
Measure = CALCULATE(SUM([value]),TOPN(5,ALL(Table1),[value]))

Please share a simple data for me to test.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for the prompt feedback. I suspect the issue may relate to my computer language setup or power bi version. Is there a way for me the send you the data and topn function as an attachment rather than a printscreen?

 

 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    My pbix

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi, just to let you know that I have installed the latest power bi desktop and open your file from there, I got the same error message with your function.