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,

I thought you were only going to create Card Visualizations for those.

Once again, sorry for my misunderstanding.

 

Please check the below measures and link.

 

Store Sales =
CALCULATE( [Sales], FILTER(ALLEXCEPT(Sales, Sales[Store]), [Budget] = 0))
 
Store Budget =
CALCULATE( [Budget], FILTER(ALLEXCEPT('Sales', 'Sales'[Store]), [Sales]=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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Hello

Yes, I was trying to show them on a card, but the values on the cards are not yet as expected, so I also added them to the grid to look for faults. Note: I changed the data for store 1 from the pbix file.

The total budget in non-sales stores should be £35

Total sales in non-budget stores must be £10

In both cases, it incorrectly includes rows from Store 1, which has sales and budget at the store level.

duncanUK_0-1617698093338.png

Thank you again,

Duncan

  • 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