Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
fe_username
Helper I
Helper I

DAX - PowerBI does not recognize Boolean Column

Hi,

I've a table from my sql dedicated pool in Azure Synapse (SQL Server 12) with all the version of applications in our server, date and obsolence (boolean).

The "Obsolescense" field is declared as BIT in my DDL and my report reads from this table.

 

The problem is that when I check the numbers from sql queries 
select count(*) from applications_table where obsoleted = 0 /1 

and the measure in dax which I use :

Application supported count =
VAR c = COUNTROWS(FILTER( <table_application>,<table_application['obsoleted'] = FALSE()))
return IF(ISBLANK(c),0,c)
 
They don't match.
- I've tried to reload several times the source
- Checked in PowerBI if the datatype of obsoleted field is True / False
- No filters modify the filter context
 
Does PowerBI have some problem with Recognizing True / False from SQL server ?
1 REPLY 1
HotChilli
Super User
Super User

"They don't match." - Are you getting errors or is the value mismatched by a certain amount?  I think we need to find that out first.

Is the data imported?

Can you show us a picture of the data view in powerbi with the column selected? Maybe also one from Power Query ? 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.