cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## DAX

Hi Community,
Help me with the DAX to Display Total in Card.

Id and Count, Eliminate are Raw Data.
Target is dynamic user input.
Difference is Count-Target (Obtained by DAX)
Negative Difference is obtained by DAX - Abs of Negative Value in Difference

Help me with DAX to display the total of Negative Value in Card Visual (i.e 56).

Sowmiya

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Ok! Try this:

```Negative Value =
SUMX (
SUMMARIZECOLUMNS (
'Table'[ID],
"Diff", [Difference],
"Negative Difference", IF ( [Difference] < 0, ABS ( [Difference] ), 0 )
),
[Negative Difference]
)```

7 REPLIES 7
Community Champion

@Sowmiya

Try this measure:

`Measure = CALCULATE((SUM('Table'[Count]) - SUM('Table'[Target])), FILTER(ALLEXCEPT('Table', 'Table'[ID]), 'Table'[Count] < 'Table'[Target]))`
Anonymous
Not applicable

Hi @Sowmiya,

You can create the calculate column [Negative Difference] with this formula:

`= IF(Table[Difference]< 0,ABS(Table[Difference]),0)`

Then you can create a measure:

`Negative Value = SUM (Table[Negative Difference])`

After that put this measure in Card Visual.

Best Regards

Chiara

Helper III

HI,
No it does not work, Argument of SUM accepts only Column not Measure (Table[Negative Difference])

Anonymous
Not applicable

As I have written, You must create a calculate column [Negative Difference], and pass it as the argument of SUM.

Helper III

Hi @Anonymous,
In Screenshot, It is a table Visual.

Count  is obtained by count of each ID. ID 35 has occured 254 times , ID 36 - 290 times. In my case, Negative Difference DAX cannot be added as Column. It must be added as measure. How can I visualize the Total of Negative Difference in Card visual using DAX in measure?

Anonymous
Not applicable

Ok! Try this:

```Negative Value =
SUMX (
SUMMARIZECOLUMNS (
'Table'[ID],
"Diff", [Difference],
"Negative Difference", IF ( [Difference] < 0, ABS ( [Difference] ), 0 )
),
[Negative Difference]
)```

Anonymous
Not applicable

It works for me!

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors