Forum Discussion
Restricting Values for Total
Hi adaocabelo,
Here I made an sample as your description. I created two measures to meet your requirement.
CA1L = MAX(opaRametro[Value])/CALCULATE(COUNT(opaRametro[Product]))
Measure = SUMX(opaRametro,[CA1L])
Then we can get the result as we excepted.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/eakbjcoo32a90l6/Restricting%20Values%20for%20Total.pbix?dl=0
Regards,
Frank
Sorry, but, how do I use that?
Think my filter is a bit harder to apply then the one on the example.
On the example the filter was "amount >1000", I need to filter only one result for each product and sum that.
All Selected function is not working for this purpose.
How should I refer on the filter to have these results?
The example is just that, an example. Each formula is going to be different. For example, your total line might be something like:
= ... DIVIDE(SUMX(ALLSELECTED(Table),[Value]),COUNTX(ALLSELECTED(Table),[Value]))
Or, now that I am looking at this a little closer, couldn't you just use a standard Average aggregation? Or is Value a measure?