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:

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
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: