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

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
fansari16's avatar
fansari16
Frequent Visitor
7 years ago

Thanks 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.