Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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...
v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Syndicate_Admin,

 

Maybe you need delete the function 'ALL'.

 

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
    Administrator
    5 years ago

    Thank you for your response.

    No, it's not solved by removing the ALL. If I take it off, it has exactly the same behavior.

    I don't think I'm doing that SELECTEDVALUE formula thing right. In the same .pbix I have another similar problem.

    I have a "Has One Filter? • ISCROSSFILTERED('AFO Global Report'[Project Code])" so that if I segment by "Project Code" I will return data in some visuals.

    If I select a project,

    kikejnt_0-1622097157032.pngkikejnt_1-1622097179884.png

    But if I select two, it leaves those objects blank.

    kikejnt_2-1622097243187.png

    kikejnt_3-1622097259214.png

    The formula for Event Description is: IF([Has One Filter?],SELECTEDVALUE('AFO Global Report'[Last Quality Event Description],BLANK()))

    And for Event Date: IF([Has One Filter?],SELECTEDVALUE('AFO Global Report'[Last Quality Event Date]),BLANK())

    Always using my measure "Has One Filter?" (which is actually a CROSS), to make if I select one or two in slicer I will return data, and if I don't leave it blank.

    Let's see if you can help me!

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

      Hi Syndicate_Admin,

       

      Oh, I got it! I got the wrong direction before.😝

      Please refer the definition of the functions:

      https://docs.microsoft.com/en-us/dax/hasonefilter-function-dax

      Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.

      If you choose two slicer options, it will return Blank().

       

      For your first issue:

      Please refer:

      https://docs.microsoft.com/en-us/dax/selectedvalue-function

      Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

      So, what is your expected output for the measure?

       

      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
        Administrator
        5 years ago

        Thanks in advance.

        What I expect from the measure is that if I filter by two Projects, I give two results here:

        Z event for one

        Event X for another

        (e.g.)

        kikejnt_0-1622108381482.png

        How could I do that? I have to touch the formula: "Have You One Filter? ISCROSSFILTERED('AFO Global Report'[Project Code])"; or I have to touch the formula: "Event Description is: IF([Has One Filter?],SELECTEDVALUE('AFO Global Report'[Last Quality Event Description],BLANK()))"

        I don't know if what's wrong is the Blank() or that I don't have "alternateResult".