Forum Discussion

pimgo's avatar
pimgo
New Member
5 years ago
Solved

If Statement wrong column total (with greater than)

Dear all,   I have been searching for the correct solution the whole day, but unfortunately I have not found it yet. When incerting the following DAX code as new measure I get the incorrect colomn ...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, pimgo 

    Thank you for sharing.

    Please check the link down below, that I included the fixed version of two measures.

    I hope I correctly understood your question.

     

    https://www.dropbox.com/s/hzfvlnxo55rc8fj/Uitlegmodel.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

pimgo's avatar
pimgo
New Member
5 years ago

Dear Jihwan_Kim ,

 

It  took some time to do it, but here is the link to the pbix file:  [deleted]  I hope this works for you? I inserted the calculatings which are correct. Unfortunately your suggestion does not work. 

 

Hopefully with the example it becomes clear what I mean. 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, pimgo 

Thank you for sharing.

Please check the link down below, that I included the fixed version of two measures.

I hope I correctly understood your question.

 

https://www.dropbox.com/s/hzfvlnxo55rc8fj/Uitlegmodel.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

  • pimgo's avatar
    pimgo
    New Member
    5 years ago

    Thank you very much, I didn't know I had to do something with the 'first ' colomn too. For the people intrested in the solution: 

    Gasketel draaiuren fix = 
SUMX (
    SUMMARIZE(
        VasteWaarden,
        VasteWaarden[Uur],
        VasteWaarden[dT],
        "@gasketel draaiuren", IF ( [Gasketel kWh] > 0, SUM ( VasteWaarden[dT] ), 0 )
    ),
    [@gasketel draaiuren]
)

     

    I had two columns (in the same table) of which the first one shows the unique values. Thank you Jihwan_Kim