Forum Discussion

o59393's avatar
o59393
Post Prodigy
5 years ago
Solved

Total values incorrectly returning 0

Hi all   I have created some if selected dax mesaures, they work perfectly when you select the respective value (project type).   The only problem I have is when you select all the project types,...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, o59393 

    Please try the below measure for the TOTAL FIX.

    The link is down below.

    If the number is incorrect, please let me know what number you want to see.

     

    Final Cost Tons total fix =
    SUMX (
    CROSSJOIN ( 'Query1 (3)', VALUES ( 'Productivity Central'[Project type] ) ),
    [Final Cost Tons]
    )

     

     

     

    https://www.dropbox.com/s/waldisbkgvaakkz/Example%20PBIx.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Portrek's avatar
Portrek
Resolver III
5 years ago

Hi.

 

It is returning zero because it was the value that you determined as final in its measure..

 

 

 

Put a function sum from your table/collumn and solve the problem.

 

Beast regards.

  • o59393's avatar
    o59393
    Post Prodigy
    5 years ago

    Hi Portrek 

     

    I removed the 0, and placed this in the false statement instead. It didnt work either

        IF(
    SELECTEDVALUE(
        'Productivity Central'[Project type])="Reduccion",

SUMX(
    SUMMARIZE(
        'Query1 (3)','Query1 (3)'[Merged],
        "Kg Inicial",[Valor Inicial],
        "Liters AC",[Liters AC],
        "Cost Inicial",MAX('Productivity Central'[Valorinicial(CostoporTONde]
                )
            ),
        [Kg Inicial]*[Liters AC]*[Cost Inicial]
    )
)
+
IF(
    SELECTEDVALUE(
        'Productivity Central'[Project type])="Aligeramiento",
SUMX(
    SUMMARIZE(
        'Query1 (3)','Query1 (3)'[Merged],
        "Kg Inicial",[Valor Inicial]/1000000,
        "Individual Units AC",Sum('Query1 (3)'[Units]),
        "Cost Inicial",MAX('Productivity Central'[Valorinicial(CostoporTONde]
                )
            ),
        [Kg Inicial]*[Individual Units AC]*[Cost Inicial]
    )
+
IF(
    SELECTEDVALUE(
        'Productivity Central'[Project type])="Empaque",
SUMX(
    SUMMARIZE(
        'Query1 (3)','Query1 (3)'[Merged],
        "Kg Inicial",[Valor Inicial],
        "Individual Units AC",Sum('Query1 (3)'[Units])
            ),
        [Kg Inicial]*[Individual Units AC]
    )

     

    Same for the measure Final Cost Tons total fix

     

    Can you help how it should really be?


    Thanks.