Forum Discussion

duncanUK's avatar
duncanUK
Frequent Visitor
5 years ago
Solved

Adding calculated total

I'm quite new to DAX and I'm struggling to add a measure, which I thought should be straightforward, but despite a lot of searching online and testing, I can't achieve the desired result. Any guidanc...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi,

    Sorry that I kept misunderstanding your point.

    I am not quite sure how to display the numbers in the table visual and the card visuals.

    please check the below link if it is OK with you.

    I think the numbers in card visuals are correct. 

    If you want to fix the numbers in the table visual, please let me know how to describe it.

    Thank you.

     

    https://www.dropbox.com/s/h9v89dyyj3fsnty/duncan.pbix?dl=0 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi,

Please kindly check the data.

I don't think it is the same data.

What you expected is shown in the link.

But, what you are showing by screencapture is different.

 

Please check the link that I replied to you at the most latest time.

 

Thank you.

duncanUK's avatar
duncanUK
Frequent Visitor
5 years ago

Hi,

 

Yes as meantion I changed the data for Store 1 to show that the solution doesn't work in the situtations where there are rows with sales = 0 or budget = 0, where these are > 0 at store level.

 

Unfortunately the real life data I'm working with has such rows.

 

Thanks,

Duncan

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi,

    Sorry that I kept misunderstanding your point.

    I am not quite sure how to display the numbers in the table visual and the card visuals.

    please check the below link if it is OK with you.

    I think the numbers in card visuals are correct. 

    If you want to fix the numbers in the table visual, please let me know how to describe it.

    Thank you.

     

    https://www.dropbox.com/s/h9v89dyyj3fsnty/duncan.pbix?dl=0 

  • duncanUK's avatar
    duncanUK
    Frequent Visitor
    5 years ago

    Perfect, thank you!