Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Help with dax formula

Hello community! I have this formula. Copy and paste formula and paste image below. INVESTMENT MEUR LAST FORECAST for TABLE = var _lastdate = CALCULATE(MAX('AFO & SAP BW_Situación Económ...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

good!

Thank you for your reply, but I'm afraid in this case the measure is not correct.

kikejnt_0-1622183526149.png

The measure would be like that anyway, wouldn't it? 

Measure=
IF(
     ISFILTERED('AFO Global Report'[Project Code]),
     CALCULATED(
         MAX('AFO Global Report'[Last Quality Event Description]),
         FILTER(
            'AFO Global Report',MAX('AFO Global Report'[INDEX])
         )),
     BLANK()
)

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Syndicate_Admin,

 

Ah, sorry, I made a mistake.

You are right.

Anyway, does it work well?

 

Best Regards,
Link

 

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

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Hello!

    Thank you, as usual.

    In this case it is not good for me because it shows me project value with the highest "index". And what I want is for you to show me a value for each project selected in the multiple segmentation selection.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Syndicate_Admin

     

    Sorry, could you provide your pbix after removing sensitive information?

    I will try it in my environment.

     

    Best Regards,
    Link

     

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