Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Count last Entry per Order

Hello! I have 2 tables: The first table (Sales Header) contains some basic information on order level. That means one row per order: Order-Nr Date Value 258 01.02.2021 50 938 13.12.2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago
try this
Column =
var maxValue =
CALCULATE (
MAX ( 'Table (2)'[steps] ),
ALLEXCEPT ( 'Table (2)', 'Table (2)'[order] )
)
return
if ('Table (2)'[steps]=maxValue , 1)

 

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Anonymous : Thanks, that works fine! What is, if a need a sub/ grand total? Then this measure will not work, right? I guess I need a countrows. How would you do that?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    @joshua1990 From the visualization pane, go to the FORMAT of visual, and from there, you can keep the google buttons ON for subtotal. Pls, look at the Screenshots I have added.

    Pls approve my reply and let me know if you have any further queries!