Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Summing visibles rows Dax

Hi, I´m really new on Dax and I can do just basic things. I´m studying and reading but at this very moment I need to solve this in my job. I hope somebody can help me.

I have a pivot table like this:

I need in the Zona's rows sum the values below. For example in Zona 4 in 2 not 0 and in my grand total I need 2 not 0. This the \$ Meta al corte formula:

IF (

ISBLANK ( [\$ Venta 2024] ) = TRUE,

BLANK (),

IF (

[\$ Venta 2024] >= [\$ Meta al corte],

1,

0

)

)

Thank you in advance

1 ACCEPTED SOLUTION
Super User

Hi,

Does this measure work?

Measure = countrows(filter(Values(Data[Sucursal]),[\$ Venta 2024] >= [\$ Meta al corte]))

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
4 REPLIES 4
Super User

Hi,

Does this measure work?

Measure = countrows(filter(Values(Data[Sucursal]),[\$ Venta 2024] >= [\$ Meta al corte]))

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

Hi Ashish I took your formula and it wors, thank you very much. I´ll keep studing to undestand this little things, You saved me!!!

Super User

You are welcome.

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

Hi Ashish, I really appreciate your answer unfortunately at this very moment I don't have access to my data model. I will come back on Monday to my job and as soon as possible I will check your formula and I will tell you if it works.

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors