Forum Discussion
Help: Adding Two Filtered Totals Together / Manual Input
Hi!
This situation seems to be related to modeling.
Most of times, when we have a measure that calculates properly when no filter is applied, but shows blank when filters from different tables are applied, it tells us that the relationship between those tables aren't functioning.
I don't know if I understood your second situation.
I'll need more detail about the table where the column created with de GENERATESERIES and about where it is applied (a slicer?).
Thanks for the reply!
I messed with the relationships involved with the totals that need to be added together, but still am not able to get a combined total - and now my multiplication measure to figure a percentage has stopped working. I've changed the data so it's using the same table, same data source - just 2 different sets of filters spitting 2 different totals into 2 table visuals. There's got to be an obvious step that I'm missing to be able to use the totals in measures.
The GENERATESERIES table was used to create a series of 1-10000 and was added to a slicer as a "Single Value" option. Basically, since I wasn't able to figure the totals of the two sets of slicers, I wanted a field where the numbers could be entered manually for a different set of calculations. But when I enter 150, it defaults to 121.
The overall model I am trying to accomplish is this:
- ONE data source
- User selects slicers to get first total number.
- User selects second set of slicers to get a second (additional) number.
- Both totals added together, and combined number is used in a set of calculations to figure a dollar amount.