Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Removing total value in report

How can I remove total value in  report with following dax code:   select_identity:= Var identity = CALCULATE(FIRSTNONBLANK(VALUES('identity'[identity description]);1)) Var identitydb= CALCULATE(...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Anonymous 

    You can use ISINSCOPE for this.

    The measures I'm using in this example are:

    1) your calculation

    Switch = 
VAR Identity = MAX('Sample'[Identity])
VAR dbident = MAX('Sample'[Indetitydb])
RETURN
IF(
ISBLANK(Identity),
dbident,  
Identity)

    2) Measure to remove total:

    Remove total = IF(ISINSCOPE('Sample'[Index]), [Switch])

     

    To get his:

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

It's a simple table in report .

Yes, the column is in the table (in report) and the column name is 'Identity description' and depending to which one ('identity' or 'identitydb') is NULL it would show value to the one which is not NULL.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous Did PaulDBrown 's suggestion work? Seems like the way to go.