Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Vanessa250919
Helper V
Helper V

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[FNGF_VOLUME_ORG]),MASTERTABLE[FNGF_VOLUME_ORG]<>0 / CALCULATE(COUNT(MASTERTABLE[DAY_DATE]),pivot[FNGF_VOL_ORG]<>0))
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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

2 REPLIES 2
Greg_Deckler
Super User
Super User

@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
Super User
Super User

@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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.