Forum Discussion

Arul's avatar
Arul
Super 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 results

 

 

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

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super 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