# Visual-level formulas

Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells | |

Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group | |

Perform one-click contribution and variance analysis without using DAX | |

Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers | |

Add custom calculations as columns and measures without having to create new DAX measures or calculated columns in the data table | |

Insert static, calculated, contribution and template rows in Power BI | |

Configure the column total and subtotal calculations when inserting calculated rows | |

Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation | |

View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields |

Last modified 5mo ago