Help with measure distinct positive and negative acumulated values

[ruinaldo]

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.

[Anonymous]

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

[ruinaldo]

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

[Anonymous]

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])

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[amitchandak]

@ruinaldo , Try a measure like

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

[ruinaldo]

Hi,

Thanks for your help. But didn´t work,

The result is:

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