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
Whatever1
Helper I
Helper I

Measure Only Showing for Some Rows

I have the following data table:

Whatever1_0-1606318003534.png

I want a matrix that always compares the amounts to the big amounts. I created a measure that I thought would always give me the total of all the Big amounts:

 

AllBig = calculate(sum([Amount]),Table1[Group]="Big")
 
However, my matrix only shows the AllBig amounts that are in the same section and not for the other rows:
 
Whatever1_0-1606319065033.png

How do I get AllBig to show for all Sections?

 

This example isn't realistic but I tried to simplify the issue to the smallest set of data that showed the problem.

 

 

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

Hi, @Whatever1 , if you want such a result,

Screenshot 2020-11-25 225620.png

you might want to try this measure

AllBig = 
CALCULATE (
    SUM ( [Amount] ),
    Table1[Group] = "Big",
    ALLEXCEPT ( Table1, Table1[Color] )
)

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

4 REPLIES 4
CNENFRNL
Community Champion
Community Champion

Hi, @Whatever1 , if you want such a result,

Screenshot 2020-11-25 225620.png

you might want to try this measure

AllBig = 
CALCULATE (
    SUM ( [Amount] ),
    Table1[Group] = "Big",
    ALLEXCEPT ( Table1, Table1[Color] )
)

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

@CNENFRNL 

 

Thank you! I have been banging my head against the wall with this and just couldn't figure out why it wasn't working.

amitchandak
Super User
Super User

@Whatever1 , Try like

AllBig = calculate(sum([Amount]),filter(Table1,Table1[Group]="Big"))

That makes it show on only one row:

 

Whatever1_0-1606326706793.png

 

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.