Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)

How can I have a measure which shows the ratio as a percentage in the scoreboard Power Bi from the following data

YEAR    MONTH   TYPE    AMOUNT
2020    Jan A   100
2020    Feb A   250
2020    Mar A   230
2020    Jan B   158
2020    Feb B   23
2020    Mar B   46
2019    Jan A   499
2019    Feb A   65
2019    Mar A   289
2019    Jan B   465
2019    Feb B   49
2019    Mar B   446
2018    Jan A   13
2018    Feb A   97
2018    Mar A   26
2018    Jan B   216
2018    Feb B   264
2018    Mar B   29
2018    Jan A   314
2018    Feb A   659
2018    Mar A   226
2018    Jan B   469
2018    Feb B   564
2018    Mar B   164 

I want to show data as shown in the figure

enter image description here 

1 Answer

0 votes
by (22.5k points)

Follow these three measures

amount_A = 
CALCULATE(
    SUM(pie_chart_data[AMOUNT]),
    FILTER(
        ALLSELECTED(pie_chart_data),
        pie_chart_data[TYPE] = "A"
    )
)
amount_overall = 
CALCULATE(
    SUM(pie_chart_data[AMOUNT]),
    ALLSELECTED(pie_chart_data) 

) 

amount_A_percentage = [amount_A]/[amount_overall] 

 For more information on Power Bi, check the following Power Bi Tutorial

Also, do check out our YouTube video on Power BI visualization techniques:

 

Related questions

0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 13, 2020 in BI by Chris (11.1k points)

Browse Categories

...