Forum Discussion

Arul's avatar
Arul
Icon for Super User rankSuper User
2 years ago
Solved

Matrix Total Different Results

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 ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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