- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Having issues summing a table correctly
I have a table visual in my report that pulls entirely from a single table. This table contains several calculated columns written in DAX. One of these columns takes the sum of the previous 3 and returns a value based on a SWITCH statement. I am attempting to SUM the values in this SWITCH statement column to get the total at the bottom. Previously I was using the following measure:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I switched some relationships around and ended up doing a simple SUM using a card visual. However, to answer your question, Cyclestar pay is a calculated column (SWITCH statement), but I also have it written as a measure (the measure is not currently being used).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please let me know if [CycleStar Pay] is a measure or it is a column in the table. If it is a measure, can you please specify the measure code.
Thanks!
-Ayan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I switched some relationships around and ended up doing a simple SUM using a card visual. However, to answer your question, Cyclestar pay is a calculated column (SWITCH statement), but I also have it written as a measure (the measure is not currently being used).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @Black_magic100
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @Black_magic100
This looks like a measure totals problem. Very common. See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If you still have the problem, please share a simple sample pbix file.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-24-2024 06:08 AM | |||
04-30-2024 06:41 AM | |||
07-30-2024 02:30 PM | |||
03-14-2023 07:27 AM | |||
07-17-2024 02:25 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |