Help with a comparative measure

[Anonymous]

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.

[Whitewater100 · Accepted solution]

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 like

 Final = 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.

[Anonymous]

It worked ! I've just changed a little bit, but the idea was correct.

pecas_expostas_comparative:=IF([Month Equiv] = COUNT(fact_share[CountColumn]),[sum peças_expostas],BLANK())

Many many tks !