Forum Discussion

brian0782's avatar
brian0782
Icon for Helper II rankHelper II
5 years ago
Solved

DAX measure producing duplicates

Hi   I've written the below DAX and included ALL to ignore any page level filters   Total Cases = CALCULATE(COUNTX('Case Record','Case Record'[Case ID]), FILTER(ALL('Case Record'),'Case Record'[...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey brian0782 ,

     

    is the column "Week" also from the table 'Case Record'?

    If yes, with the ALL you also remove the filter of Week, so every time you get the total.

     

    Maybe if that's the case, the following approach could work:

    Total Cases =
CALCULATE(
    COUNT( 'Case Record'[Case ID] ),
    ALLEXCEPT(
        'Case Record',
        'Case Record'[Week]
    ),
    'Case Record'[Case Type ID] = 1
)

     

    It would be helpful to get more information or even better the file in order to help you.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey brian0782 ,

 

is the column "Week" also from the table 'Case Record'?

If yes, with the ALL you also remove the filter of Week, so every time you get the total.

 

Maybe if that's the case, the following approach could work:

Total Cases =
CALCULATE(
    COUNT( 'Case Record'[Case ID] ),
    ALLEXCEPT(
        'Case Record',
        'Case Record'[Week]
    ),
    'Case Record'[Case Type ID] = 1
)

 

It would be helpful to get more information or even better the file in order to help you.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • brian0782's avatar
    brian0782
    Icon for Helper II rankHelper II
    5 years ago

    This worked well. Thanks for the explanation 😁