@GM17 wrote:
Hi All,
I measure column below in a table-
IF(ISBLANK(CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0)))),0,CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0))))
The details row in the table gives the correct result while Total is not returining the correct value? Please suggest the way so that total returns the correct value.
@GM17
I don't find something wrong with that measure. As to the incorrect Total, could you post any sample data and snapshots? By the way, for better readability, the measure can be
your measure =
VAR value =
CALCULATE (
DISTINCTCOUNT ( VW_PRS_LCS_Activity[LCSACT_ActID] ),
FILTER (
VW_PRS_LCS_Activity,
( VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work"
&& VW_PRS_LCS_Activity[LCSACT_ActPastDue] > 0 )
)
)
RETURN
IF ( ISBLANK ( value ), 0, value )
