Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
DAX
if
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    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.
     
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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 !