Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Quickly DAX measure fix - Filter

Hi, I want to slightly modify my measure. Currently, it looks like that:  Aging = VAR ItemID = SELECTEDVALUE(WH_Invent_Trans[ItemID]) RETURN DATEDIFF(MAXX( FILTER(ALL(WH_Invent_Trans); WH...
all
DATEDIFF
Filter
MAXX
Variable calculation
  • Mariusz's avatar
    Mariusz
    6 years ago

    hej pawelj795 

     

    W pliku ktory wyslales nie bylo tego obiektu wiec musiale go wylachys z formuly.

     

    Zalaczylem plik z formua.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi pawelj795 

 

sprobuj tego

date = 
VAR __dates = 
    GROUPBY(
        CALCULATETABLE(
            WH_Invent_Trans,
            KEEPFILTERS( WH_Invent_Trans[TransType] IN { 0, 9 } ),
            KEEPFILTERS( WH_Invent_Trans[QTY] <> BLANK() ),
            ALLEXCEPT( WH_Invent_Trans, WH_Invent_Trans[ItemID] )
        ),
        WH_Invent_Trans[ItemID],
        "@maxDate", MAXX( CURRENTGROUP(), WH_Invent_Trans[DatePhysical] )
    )
RETURN MAXX( __dates, [@maxDate] )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.
pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Mariusz 
Can you help me?
With your new measures my total are twice as big than whole inventory value(2,16 m vs. 1m)