Calculating percentage change through time

Question

Hi I am new to PowerBi and I have a data set with two columns: date and action type(ABC, DEF, GHI). I am interested to find the percent change in the ABC action type through the years with the forumla of ABC/(DEF+GHI), but how would I go about calculating that and then doing a line graph? Specifically with the line and clustered column chart.

v-chuncz-msft · Accepted Answer

Anonymous&nbsp;,
&nbsp;
You may try adding measure below.
Measure =
DIVIDE (
    COUNTROWS ( FILTER ( Table1, Table1[type] = "ABC" ) ),
    COUNTROWS ( FILTER ( Table1, Table1[type] IN { "DEF", "GHI" } ) )
)

Forum Discussion

Related content

Calculate Percentage

Calculating Percentages

percentage calculation

Calculate percentage

Percentage Calculation