Forum Discussion

fansari16's avatar
fansari16
Frequent Visitor
7 years ago
Solved

Clustered column chart help

Hello BI community,   I am new to POwer BI & I am loving it so far. Recently I have encountered a problem. I am trying to compare results of two quarters ( from a survey). When I draw two separate...
  • stretcharm's avatar
    stretcharm
    7 years ago

    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
stretcharm's avatar
stretcharm
Memorable Member
7 years ago

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
stretcharm's avatar
stretcharm
Memorable Member
7 years ago

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