cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lennard96
Regular Visitor

Problem with total statement

Hi ,

i have a problem with my total statement. I have seen that others have got the same issues, but i can't use their solution for my measure. @Ashish_Mathur You were able to help someone else with a similar problem. Do you have a solution for that? 🙂
I have to measure "Product 1 sum at last" - "Product 1 sum at first". I only want to consider the positive values in my result of the measure "Without negative Values". I have attached a screenshot for you and the measures. I tried a Hasonefilter, but it does not work. Do you have a solution for my problem? You would help me a lot. Kind regards Lennard .

 

Product 1 sum "at first" = CALCULATE(SUM('Tabelle1 (2)'[Produkt 1 sum]),'Tabelle1 (2)'[first/ last]="@first")
Product 1 sum "at last" = CALCULATE(SUM('Tabelle1 (2)'[Produkt 1 sum]),'Tabelle1 (2)'[first/ last]="@last")

 

Without negativ Values = IF(HASONEVALUE('Tabelle1 (2)'[Month]), IF([@last - @first]>0,[@last - @first],0))
File.PNG
1 ACCEPTED SOLUTION

Remove the second HASONEVALUE


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User III
Super User III

Hi,

Does this measure work?

=If(hasonevalue(HASONEVALUE('Tabelle1 (2)'[Month]),[Without negativ Values],sumx(summarize(values('Tabelle1 (2)'[Month]),'Tabelle1 (2)'[Month],"ABCD",[Without negativ Values]),[abcd]))

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Unfortunately not, i get this error message:

 

"Too many arguments were passed to the HASONEVALUE function. A maximum of 1 arguments are allowed for the function."Test 2.PNG

 

Remove the second HASONEVALUE


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Thanks a lot. It works 🙂

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!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.

Top Solution Authors