Solved: Re: Filter + divide

Vanessa250919 · ‎08-02-2021

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[FNGF_VOLUME_ORG]),MASTERTABLE[FNGF_VOLUME_ORG]<>0 / CALCULATE(COUNT(MASTERTABLE[DAY_DATE]),pivot[FNGF_VOL_ORG]<>0))

Fowmy · ‎08-02-2021

@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 
    )
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Greg_Deckler · ‎08-02-2021

@Vanessa250919 Should be possible but not really enough to go on. Are you getting a problem with the formula? Is your relationship between mastertable and pivot present and in the right direction?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Fowmy · ‎08-02-2021

@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 
    )
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group