Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting percent on row while counting some columns

I have a situation where I have a table with individual feedback scores and want to produce a matrix showing rating groups and their percentage of the  year's total feedback but I don't want to add c...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi Anonymous 

     

    I got this!

    Percentage Measure = 
VAR Numerator =
    CALCULATE(
        [FeedbackCount],
        'Customer Feedback'[feedback score] <> 0
    )
VAR Denominator =
    CALCULATE(
        [FeedbackCount],
        CALCULATETABLE(
            'Customer Feedback',
            'Customer Feedback'[feedback score] <> 0,
            REMOVEFILTERS('Customer Feedback'[feedback score (groups)])
        )
    )
RETURN

DIVIDE(
    Numerator,
    Denominator,
    BLANK()
)

     

     

  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Anonymous try another measure...should be something like this (maybe???)

    CALCULATE(
	[The Measure I Gave You Earlier],
	[Group/bin] = "6-7"
)

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have a somewhat related question...if possible I'd like to use the value in the total row at the bottom of the 6-7 column (83.3%) in a card up top on the page...is there any easy way to get it? I'm guessing I need another measure(my guess), but would it be similar to what you helped with?

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Anonymous try another measure...should be something like this (maybe???)

CALCULATE(
	[The Measure I Gave You Earlier],
	[Group/bin] = "6-7"
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    ok! I tried that a little, but it's the second parameter that I didn't add....thanks! those extra parameters get me every time.  Tried it as I typed and that did it. Thanks!!