Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

TOP N Column Sum without Filter

Hello Community,   i have a question. I made a Table with Top N Values. But instead of the percetage for the Column Sum with Top N Filter i want it for the Column without the Top N Filter. Can some...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Download my PBI file from here.

     

    Hope this helps.

     

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

please excuse but I do not understand your requirements.

 

Please conisder to create an Excel xlsx workbook, that contains sample data, create a sheet that contains your expected result and also describe how some filtering may effect the reuslt.

 

Providing sample data reduces the effort to create a working solution and also avoids misunderstandings.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Tom,

 

since your footer says Hamburg Germany...

will ich mich einfach halten. Ich habe eine Tabelle und wenn ich den Top N Filter verwende, wird die Summe der Spalte an das TOP N angepasst. Und ich hätte gerne dennoch die volle Summe. Denn sonst ist das prozentual abweichend von dem tatsächlichen Wert.

Ist sowas möglich über das Quick Measure? Ansonsten bereite ich morgen ein Testdatei vor.

 

Vielen Dank.