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.
Hi!
I believe it could be helpful if you could share an example of your data, it doesn't need to show actual values, you can change it to random values and fictional descriptions.