Forum Discussion
Clustered column chart help
Using your sample document this Measure will give the correct percentages.
PerOfQuarter = VAR QtrTotal = CALCULATE ( COUNT('Form Responses Q1 and Q2'[Timestamp]) , ALLEXCEPT ( 'Form Responses Q1 and Q2', 'Form Responses Q1 and Q2'[Quarter] ) ) RETURN COUNT('Form Responses Q1 and Q2'[Timestamp]) / QtrTotal
It looks like your using show as % of Grand Total. The total has changed by adding both Quarters which affects the figures.
Try creating your own dax that calculates by Quarter. Something like this.
PerOfQuarter =
VAR QtrTotal =
CALCULATE ( SUM ( Rating[Count] ), ALLEXCEPT ( Rating, Rating[Quarter] ) )
RETURN
SUM ( Rating[Count] ) / QtrTotal
Using your sample document this Measure will give the correct percentages.
PerOfQuarter = VAR QtrTotal = CALCULATE ( COUNT('Form Responses Q1 and Q2'[Timestamp]) , ALLEXCEPT ( 'Form Responses Q1 and Q2', 'Form Responses Q1 and Q2'[Quarter] ) ) RETURN COUNT('Form Responses Q1 and Q2'[Timestamp]) / QtrTotalThanks a lot stretcharm. Really appreciate your help & expertise. Can you guide how & where to add this measure?
Unfortunately I am new to powerBI. Or can you share your PowerBI file so that I can see how you did that. That would be a huge help.
stretcharm You are a genious. I got it. Thank a lot. I deeply appreciate your help.
Hopefully you've got it working now.
Check out this list of PowerBI training links that will help you
https://community.powerbi.com/t5/Desktop/Good-Source-to-Learn-DAX/m-p/539642#M253384
