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.

Reply
Aleks_1013
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: 

Aleks_1013_0-1713640838925.png

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
Ashish_Mathur
Super User
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/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
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/

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!!!

You are welcome.


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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.