topic Re: Filter + divide in DAX Commands and Tips

Filter + divide

Vanessa250919 — Mon, 02 Aug 2021 13:44:35 GMT

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

Re: Filter + divide

Fowmy — Mon, 02 Aug 2021 13:56:38 GMT

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

Re: Filter + divide

Greg_Deckler — Mon, 02 Aug 2021 13:57:26 GMT

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?