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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
afaro
Helper III
Helper III

How to calculate sum of visible rows in this situation?

ProductSalesCategoryCoefficient
P1100Food0.2
P250Leisure0.4
P3200Food0.2
P4300Leisure0.4
P5400Leisure0.4

 

I have a table like this and I create measures like these: 

EligibleCategory = IF(MAX(Table[Category]) IN {"Leisure"}, "YES", "NO")

EligibleSales = IF(0.5*SUM(Table[Sales]) >= 50, "YES", "NO")
Taxes = IF(EligibleSales = "YES" && EligibleCategory = "YES", MAX(Table[Coefficient]) * SUM(Table[Sales]), 0)

With these measures, I should get something like this: 

ProductSalesCategoryCoefficientEligibleCategoryEligibleSalesTaxes
P1100Food0.2NOYES0
P250Leisure0.4YESNO0
P3200Food0.2NOYES0
P4300Leisure0.4YESYES120
P5400Leisure0.4YESYES160
Total950  YESYES280


Most importantly, I want to know how to write my measures in a way that the total comes out to be 280 (sum of visible rows) instead of computing the measures on the aggregate result and giving the wrong total. 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Not sure why you would need measures for this, but here goes

 

lbendlin_0-1728395607120.png

 

 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Not sure why you would need measures for this, but here goes

 

lbendlin_0-1728395607120.png

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors