Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Converting static to Dynamic Measure

Hai All, I am expecting a super solution for this requirement. The requirement is  Currently I am working on a sales dashboard and every year this report is having different versions of tables for ...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please try something like

    Measure1 =
VAR LastDateWithData =
    CALCULATE ( MAX ( MASTER[Date] ), REMOVEFILTERS () )
VAR LastVerion =
    CALCULATE (
        MAX ( MASTER[Version] ),
        MASTER[Date] = LastDateWithData,
        REMOVEFILTERS ()
    )
RETURN
    CALCULATE (
        SUM ( Sales[Values] ) / 1000,
        MASTER[Version] = LastVerion,
        ALL ( MASTER[Comparison] )
    )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
Please try something like

Measure1 =
VAR LastDateWithData =
    CALCULATE ( MAX ( MASTER[Date] ), REMOVEFILTERS () )
VAR LastVerion =
    CALCULATE (
        MAX ( MASTER[Version] ),
        MASTER[Date] = LastDateWithData,
        REMOVEFILTERS ()
    )
RETURN
    CALCULATE (
        SUM ( Sales[Values] ) / 1000,
        MASTER[Version] = LastVerion,
        ALL ( MASTER[Comparison] )
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hai tamerj1 
    This solution is not working , can i create two table for version?

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Anonymous 
      I don't know how your data and data model look like.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hai tamerj1 
        Can you check this measure