cancel
Showing results for
Did you mean:
Helper II

## Help with measure distinct positive and negative acumulated values

I have a table with 4 distinct names per month.

i want to only consider the names begins with 22, and the only acumulated positive values per month and name.

Above i report the expected result.

5 REPLIES 5
Community Support

Hi @ruinaldo ,

Sorry to disturb you again...

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Eyelyn Qin

Helper II

i try this formula and result the filter for the name 22.

In visual for the month january it´s all ok, i only have positive values in "22-green" and is 10

but how can i do it for a card? i don´t want 4 in result but 10

Community Support

Hi @ruinaldo ,

You could use the following formula to create new measure for Card visual:

``Measure2 = MAXX(FILTER(ALL('Table'),'Table'[Name]="22-green"),[Measure])``

Best Regards,
Eyelyn Qin

Super User IV

@ruinaldo , Try a measure like

calculate(sum(Table[Value]),filter(Table, left(Table[name],2)= "22" && Table[Value]>0))

Proud to be a Super User!

Helper II

Hi,

Thanks for your help. But didn´t work,

The result is:

i expected in april 22green= 10 and 22red = 1

Announcements