cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruinaldo
Helper II
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.

ruinaldo_0-1605095816858.png

 

5 REPLIES 5
Eyelyn9
Community Support
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

ruinaldo
Helper II
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

ruinaldo_0-1605114269200.png

Eyelyn9
Community Support
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])

 

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
Super User IV
Super User IV

@ruinaldo , Try a measure like

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi,

Thanks for your help. But didn´t work,

The result is:

ruinaldo_0-1605103824328.png

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.