Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
@Anonymous ,
You may try adding measure below.
Measure =
DIVIDE (
COUNTROWS ( FILTER ( Table1, Table1[type] = "ABC" ) ),
COUNTROWS ( FILTER ( Table1, Table1[type] IN { "DEF", "GHI" } ) )
)
@Anonymous ,
You may try adding measure below.
Measure =
DIVIDE (
COUNTROWS ( FILTER ( Table1, Table1[type] = "ABC" ) ),
COUNTROWS ( FILTER ( Table1, Table1[type] IN { "DEF", "GHI" } ) )
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!