Forum Discussion
Adding calculated total
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.
Hi,
Thank you for your feedback.
Sorry that I was misunderstanding your question.
Please try the below two measures for the two card visualizations.
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.
Hi,
Sorry to say but that's not working, as it includes rows from stores where the store level sales or budget > 0, e.g. in this example the measures include rows from store 1:
Thanks,
Duncan
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.
Hi
Yes I was trying to display them in a card, but the values on the cards are still not as expected, hence I also added to the grid to fault find. Note I've changed the data for store 1 from your pbix file.
The total budget in stores with no sales should be £35
The total sales in stores with no budget should be £10
In both cases it's incorrectly including rows from store 1, which has both sales and budget at the store level.
Thank you again,
Duncan
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.
Thank you again,
Duncan
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.
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.
Thank you again,
Duncan
