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

o59393's avatar
o59393
Post Prodigy
5 years ago

Hi Jihwan_Kim 

 

I created a new table like this with your formula:

 

 

Is it some kind of virtual table your measure the sums row by row all the project types?

 

Regards!

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, o59393 

I think it is.

One more thing is that the reason why I used the whole table Query1 (3) is that I could not find the primary-key-column in the table. If you know which column is the primary-key-column, then you can also try something like below.

 

Total Fix =
SUMX (
CROSSJOIN ( VALUES ( [primarykeycolumn] ), VALUES ( [projecttypecolumn] ) ),
[your measure]
)

 

Then, I think, your virtual table becomes much slimmer.