Skip to main content

Enterprise & Financial Services

Mastering CALCULATE in DAX

CALCULATE is the most important function in DAX.

If you truly understand CALCULATE, you understand how Power BI thinks.

It allows you to control filters, override slicers, ignore visuals, and apply business rules correctly. Almost every advanced Power BI measure relies on CALCULATE in one way or another.

In this article, we will explore CALCULATE in depth and clearly explain how filter modification works using:

• ALL

• ALLEXCEPT

• REMOVEFILTERS

• KEEPFILTERS

Feb 05, 2026
Rebecca Anyangu
Rebecca Anyangu

How to Visualize Aging on Overdue Payments

Overdue payments are one of the most pressing financial challenges organizations face. When invoices sit unpaid beyond their due date, cash flow suffers, and without visibility into how long payments have been outstanding, finance teams are left guessing. Power BI offers a powerful way to build an aging dashboard that not only tracks overdue payments but also highlights the severity and risk associated with each one. 

Feb 03, 2026
Annette Nyambura
Annette Nyambura

How to Restore a Database in SQL Server

Restoring a database is a fundamental task for SQL Server administrators and developers. Whether you're setting up a development environment, recovering from data loss, or migrating data between servers, understanding the restore process is essential. In this guide, we'll walk through restoring the AdventureWorks database, a popular sample database from Microsoft.
 

Jan 26, 2026
Annette Nyambura
Annette Nyambura

How to Fix Slow Command Bar Buttons in Model-Driven Apps (Stop Buttons Taking Forever to Appear)

If you’ve ever built a model-driven app in Power Apps, you’ve probably battled with slow-loading command bar buttons. You click a table, and for 3… 5… sometimes 10 seconds, your button just refuses to appear.

For ages, I kept asking:

Why are my buttons taking so long to show up, even when my formula is simple?

This blog is the answer I wish I had earlier, and the pattern that finally solved the performance problem completely.

Dec 10, 2025
Didi Kashemwa
Didi Kashemwa

eBoard by Sibasi: The Smarter Way to Run Modern Board Meetings

In today’s fast-paced business world, effective governance isn’t just a requirement it’s a competitive advantage. Boards are expected to make faster, data-driven decisions while maintaining high levels of transparency, collaboration, and security. Yet many organizations still rely on scattered documents, endless email threads, and manual preparation that slow down the entire process.

Nov 21, 2025
Annette Nyambura
Annette Nyambura

Why 8 Years Matters: Reflections From My First 3 Months at Sibasi

This month, Sibasi turns eight. In the fast-moving world of technology, eight years is not just a number it’s proof of resilience, relevance, and the ability to grow alongside the communities we serve.

I joined Sibasi three months ago, and walking into an organization with nearly a decade of history is both inspiring and humbling. From my first days, I could feel that Sibasi isn’t just a tech company  it’s a partner to nonprofits, Educational Institutions and businesses across Africa.

Sep 19, 2025
Lavenda Watila
Lavenda Watila

Reflections on the Sibasi Power BI Masterclass

Last week, I had the privilege of serving as one of the Lead Trainers in a week-long Power BI Masterclass. The primary goal of this training was to help learners gain a clear understanding of the full Power BI ecosystem, explore how it can make a tangible impact in their organizations, and equip them with the practical skills required to implement what they learned.

Aug 22, 2025
Maureen Wachira
Maureen Wachira

DynamicsCon Regional: East Africa 2025

On 24th and 25th July 2025, we attended DynamicsCon Regional: East Africa 2025, and it was an incredibly energizing and insightful experience.

We were privileged to take the stage where we talked about the integration between Microsoft Dynamics 365 and Power BI. Our session focused on demonstrating just how powerful these platforms can be when used together. Rather than just talking about it, we brought it to life with a live showcase.

 We explored;

Aug 04, 2025
Maureen Wachira
Maureen Wachira

How AI Is Challenging the World of Digital Marketing

The digital marketing world is undergoing a revolution—and AI is both the catalyst and the disruptor. From personalized recommendations to predictive analytics, AI isn’t just helping marketers work better. It’s redefining the rules of the game.

Discover how artificial intelligence is disrupting digital marketing—from automating content creation to challenging brand authenticity—and what marketers must do to adapt.

Apr 30, 2025
Annette Nyambura
Annette Nyambura
Subscribe to Enterprise & Financial Services