Forum Discussion

soji's avatar
soji
Frequent Visitor
5 years ago

Issue with Matrix Visualization

Hi    I have created a Matrix View in Power BI table as i wanted dynamic output based on the weeks selection. Here everything is working as i wanted except the Total - i need the average instead of...
soji's avatar
soji
Frequent Visitor
5 years ago

Hi Amit,

 

I have manually added the average in the sample data which i shared but in BI i am getting total instead of average.

Thanks

 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    soji , Assume you have sum measure

    the create  measures 

    average measure 1= [sum measure]/distinctcount(Table[Week])
    average measure 2= [sum measure]/distinctcount(Table[emirate])

     

     

    and use below measure in matrix

    Switch( True() ,
    isfiltered(Table[Week]) && not( isfiltered(Table[Emirate])) ,[average measure 1],
    not(isfiltered(Table[Week])) || isfiltered(Table[Emirate]) ,[average measure 2],
    [sum measure]
    )