cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## 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
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
2 REPLIES 2
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?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors