Forum Discussion

antoniodneto's avatar
antoniodneto
Regular Visitor
6 years ago
Solved

Help with Expression

Hi guys, I`m new with Power BI, can you help me?   I have one master filter on my dash called DATE, with 2001,2002..... 2007. is my contract date. And another called DATE_SELL with 2001,2002.... ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi antoniodneto ,

    You can create this measure:

    Measure =
VAR _max =
    CALCULATE ( MAX ( 'Table'[date] ), ALLSELECTED ( 'Table'[date] ) )
RETURN
    IF (
        ISFILTERED ( 'Table'[date] ),
        IF (
            _max IN DISTINCT ( 'Table'[date_sell] ),
            CALCULATE (
                SUM ( 'Table'[value] ),
                FILTER ( ALL ( 'Table' ), 'Table'[date_sell] = MAX ( 'Table'[date_sell] ) )
            )
        ),
        SUM ( 'Table'[value] )
    )

    no date is selectedselected date

     

    Attached a sample file that hopes to help you: Help with Expression.pbix

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

antoniodneto's avatar
antoniodneto
Regular Visitor
6 years ago

Hi, IT WORKED!!!

 

Just one thing, when I select month by month return me correct. But when not month is selected it shows me the value for max date_sell, in this case should accumulated. Can I add that?

 

Tks a lot!!!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi antoniodneto ,

 

Not very clear , but it accumulates the value of the max_date sell.

 

I think this is what you want.

 

Let me know if this help. 

 

Also, pls accept as solution for other community members to benefit.

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)