Forum Discussion

Vanessa250919's avatar
Vanessa250919
Helper V
5 years ago
Solved

Filter + divide

Hello I need to create a DAX formula but I can't have a good resutlt .   I need to have a SUM with filter divide by Count with filter it's possible ?    Measuretest = CALCULATE(SUM(MASTERTABLE[F...
Need Help
Need Help DAX
  • Fowmy's avatar
    Fowmy
    5 years ago

    Vanessa250919 

    Did not get it completely but try this modified version:

    Measuretest =

DIVIDE (
    CALCULATE (
        SUM ( MASTERTABLE[FNGF_VOLUME_ORG] ),
        MASTERTABLE[FNGF_VOLUME_ORG] <> 0
    ),
    CALCULATE ( 
        COUNT ( MASTERTABLE[DAY_DATE] ), 
        pivot[FNGF_VOL_ORG] <> 0 
    )
)
Fowmy's avatar
Fowmy
Super User
5 years ago

Vanessa250919 

Did not get it completely but try this modified version:

Measuretest =

DIVIDE (
    CALCULATE (
        SUM ( MASTERTABLE[FNGF_VOLUME_ORG] ),
        MASTERTABLE[FNGF_VOLUME_ORG] <> 0
    ),
    CALCULATE ( 
        COUNT ( MASTERTABLE[DAY_DATE] ), 
        pivot[FNGF_VOL_ORG] <> 0 
    )
)