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 of 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 store 1 rows, which has sales and budget at the store level.

duncanUK_0-1617698093338.png

Thank you again,

Duncan