cancel
Showing results for
Did you mean:
Frequent Visitor

## If a row is zero the total of the row should be zero

Hi,

I am trying to create a dax formula that shoud do this :

 Jan Fev March April May June July August September Nov Dec CountryA 1 0 21 3654 65 3 13 0 0 0 0 CountryB 34 58 11 645 435 4 55 4 56 5 0 CountryC 78 75 41 0 3 665 541 4 9 3 1 CountryD 0 23 4 55 684 965 654 74 55 12 1 Jan Fev March April May June July August September Nov Dec Region A (Country A+B) 35 0 32 4299 500 7 67 0 0 0 0 Region B(Country C+D) 0 98 45 0 687 1620 1195 78 64 15 2

How can I replicate this?

1 ACCEPTED SOLUTION
Super User

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

5 REPLIES 5
Super User

@TeresaV not sure what you mean? Can you be clear on your requirements in one go? Sorry, but it is hard to answer if you are going to change the question.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

sorry , it is the same problem but with another column to filter.

Basically I want to achieve the same result as before :

but instead of having just the value I want to filter the value per source... if it is 0 in country A and 25 in country B (Country A+ country B= region A) then region A will be 0.

did you understood?

Frequent Visitor

What if I have another column , named source:

and I want to filter for sorce A only??

@parry2k @Jihwan_Kim

Super User

@TeresaV I have further enhanced @Jihwan_Kim file (new pbix file is attached) and the Total shows up correctly.

here is the image:

and measure used to fix the total:

``````Result =
SUMX (
SUMMARIZE (
Data,
Months[Month],
Countries[Region],
"@Result",
VAR _valuelist = VALUES ( Data[Value] )
RETURN
IF ( 0 in _valuelist, 0, CALCULATE ( SUM ( Data[Value] ) ) )
),
[@Result]
)``````

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.