Forum Discussion
Help with a comparative measure
Hello everyone! I'm trying really hard to solve this issue, but i can't figure out how.
I have a data set with column count :
When the month is filtered on calendar table, it expected to count how many time this value on Auxultimames occurs. So if i filter Jan-Feb-Mar
It shows 1 to 3
I want to sum([peças_expostas]) only if the count is equal to the amount of itens selected in the month slicer. I want to do it dinamically.
HI:
You can try this:
First Measure:
# Rows in Dates = COUNTROWS( 'Dates' )Second Measure =Month Equiv = ROUND(DIVIDE([# Rows in Dates],30.4),0)Then you can compare your count of names with an IF Statement , something likeFinal = IF([pecas_expostas] = [Month Equiv], [Cout of Name], BLANK())I hope this helps.P.S. Your Date Table should be continuous, marked as Date Table and have relationship with your fact table.
2 Replies
Whitewater100Solution Sage
HI:
You can try this:
First Measure:
# Rows in Dates = COUNTROWS( 'Dates' )Second Measure =Month Equiv = ROUND(DIVIDE([# Rows in Dates],30.4),0)Then you can compare your count of names with an IF Statement , something likeFinal = IF([pecas_expostas] = [Month Equiv], [Cout of Name], BLANK())I hope this helps.P.S. Your Date Table should be continuous, marked as Date Table and have relationship with your fact table.