Showing values only if the value >0, show a message if value <0

[Alexandra_B]

Hello.
I have 4 categories of data: C1, C2, C3, C4.

C4 = (sum of data from a spreadsheet) - (C1+C2+C3)

The data in C4 is updated monthly for a month before, so we don`t have "live" information on it. C1, C2, C3 in live (when report is refreshed).

I would like to calculate in a way that:

- if C4>0 to show value of C4

- if C4<0 to show (data not uploaded)

Is this possible?

This is how it looks like now with just the calculation, no conditions:

This is how I would like to see if C4 >0

Thank you.

[Alexandra_B]

Hello and thank you for your reply.
No, they are all different tables.
C1, C2, C3 are from 4 different json files (converted into tables).
C4 = spreadsheet - sum(C1+C2+C3)

C4 is calculated through measure, the others have data from API.

[Rudy_D]

Hi Alexandra,

Difficult to answer without a sample of your data.

Are C1 / C2 / C3 / C4 categories from one of your table's columns ? Or calculated through measures ?

If it's from a table's column, I think you sould :

- Create 3 different measures C1 / C2 / C3 using this example for C1 : CALCULATE(SUM('Table'[Value]), FILTER (Table, 'Table'[C_Column] = C1))

- Create 1 measure for C4 :

IF(CALCULATE(SUM('Table'[Value]), FILTER (Table, 'Table'[C_Column] = C4)) < 0, BLANK(), CALCULATE(SUM('Table'[Value]), FILTER (Table, 'Table'[C_Column] = C4)))

- create a conditionnal title (using a measure) to inform users that data has not been uploaded (if C4 < 0)

Regards

Rudy