Forum Discussion

JCK2's avatar
JCK2
Icon for Helper III rankHelper III
6 years ago
Solved

Dax column calculation

Hello,   i want to create a measure to arrive at one number as how much is due in the month, I wrote teh below calculation in column, however this is not helping me achive what i want.   How does...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

JCK2 - are you looking for this?

 

Measure 2 = 
    DIVIDE(
        COUNTROWS(FILTER(FILTER('Table',DISTINCT('Table'[Id])),NOT(ISBLANK([Total Overdue 1])) && [Total Overdue 1] = 0)),
        SUM('Table'[Total Due 1])
    )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Apologies, maybe this:

Measure 2 = 
    DIVIDE(
        COUNTROWS(FILTER(SUMMARIZE('Table',[Id],"__Count",IF(NOT(ISBLANK(MAX('Table'[Total Overdue 1]))) && MAX([Total Overdue 1]) = 0,1,0)),[__Count]=1)),
        SUM('Table'[Total Due 1])
    )