Calculate the Rows Count, Ignoring Filters In Power BI

In this article, I will show How to

Calculate the total rows, Ignoring Filters In Power BI

Calculate the total rows, Ignoring Filters In Power BI


Scenario

In Power BI, I have a “Projects” table as SQL data source, I would like to show

  • The total number of rows, ignoring the filter.
  • The total number of rows, depending on the filter.

As below shown,  Continue reading “Calculate the Rows Count, Ignoring Filters In Power BI”

Advertisements

Count Blank Values In Power BI

In this article, I will show How to

Count Blank (NULL) values In Power BI Chart

Count Null values in Power BI Chart


Scenario

In Power BI, I have a data source from SQL Server Table that contains a field called “Project Status“.

The “Project Status” is not a mandatory field so it may hold a Blank or NULL value.

In Power BI, I have added a chart to show the count of “Project Status” values with the default configuration as below:

  • In Legend: Project Status.
  • In values: Count of Project Status.

Unfortunately, the configured Chart didn’t show the “No Date Items” as shown below

Show items with no data in Power BI

Continue reading “Count Blank Values In Power BI”

Install and Configure Power BI Report Server On-Prem

In this article, I will show How to

Install and Configure Power BI Report Server (Power BI On-Prem) Step By Step

Install and Configure Power BI Report Server


What’s the Power BI Report Server (Power BI On-Prem)?

Continue reading “Install and Configure Power BI Report Server On-Prem”