Matrix Total Different Results

[Arul]

Hi all,

I have two matrix visual which is having some measures one with correct total and other with wrong total. What can be the issue?

1. Showing Correct result

2. Not showing correct results

[rajendraongole1 · Accepted solution]

Hi @Arul - Can you try below measure added , region on values part. Check once to get the totals

Var value_ = IF(HASONEVALUE('Current Date'[Region]), SELECTEDVALUE('Current Date'[Region]), BLANK())
Var count_ = CALCULATE(
COUNT('Current Date'[Dem Id]),
'Current Date'[GPN] = BLANK(),
'Current Date'[Taleo Id] = BLANK(),
'Current Date'[Region] <> "NCH",
'Current Date'[Region] = value_)
Var result = IF(ISBLANK(count_), 0, count_)
Return IF(ISINSCOPE('Current Date'[Region]), result, SUMX(VALUES('Current Date'[Region]), result))

Hope it works