topic Re: Help with a comparative measure in DAX Commands and Tips

Help with a comparative measure

Anonymous — Mon, 15 Aug 2022 17:31:22 GMT

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.

Re: Help with a comparative measure

Whitewater100 — Mon, 15 Aug 2022 19:47:04 GMT

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.

Re: Help with a comparative measure

Anonymous — Tue, 16 Aug 2022 21:09:05 GMT

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 !