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

March Update

Check it Out!

Click here to read more about the March 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.

Top Solution Authors
Top Kudoed Authors