Forum Discussion

shanj's avatar
shanj
Frequent Visitor
6 years ago

Filter aggregated Card by Multiple Slicers

Hello, Very new to PowerBI. I have a measure of the rate of estimation for bills. This rate is grouped by three different dimensions f1,f2,f3. These dimensions have different number of categories. ...
Need Help
shanj's avatar
shanj
Frequent Visitor
6 years ago

For the table below, I am trying to filter the average of percent estimation by any combination of the filters. For example SSN system and Type1 type (120/400).

If I average  percent estimation column as is when no filter is applied that average is not meanngful as it is the average by system, parish,type and month. 

I would like to display the month average by default when no filter is applied.

Avg March: 54%, Avg April: 17%. Therefore the average to be displayed is 35% then filters are applied to this average.

system parish type month number estimates total reads percent estimation
SSN Town1 Type1 March 100 200 50

YP

 Town1 Type2 March 200 350 57
AMI

 

Town1

 Type2 April 10 100 10
SSN

 

Town2

 Type1 April 20 200 10
QL Town2 Type2 April 60 300 20
SSN Town2 Type2 April 40 100 40
YP Town3 Type2 March 10 110 9

 

any help would be greatly appreciated.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi shanj ,

     

    Would you please show me more details about your expected output? How did you get "Avg March: 54%, Avg April: 17%. Therefore the average to be displayed is 35% then filters are applied to this average."?

     

    Best Regards,

    Dedmon Dai