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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Quiny_Harl
Resolver I
Resolver I

SUMMARIZE table without blanks

I would like to have all unique values from a column in order to use it as a dimension table. Here is how I do that:

Quiny_Harl_0-1606490866894.png

Yet, even though I'm excluding the blank ones I still have one blank. On top of that, when I try to connect it to my fact table it says that the relationship is many to many even though I don't see any duplicate values in this table.

Will appreciate any help!

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Quiny_Harl,

In fact, blank records can be matched with multiple scenarios(blank, empty string, unrecognized special characters), I'd like to suggest you double-check your record value to confirm its type.

In addition, you can also take a look at the below blog about handle blank in Dax to know more them:

Handling BLANK in DAX 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Quiny_Harl , Try

summarize(filter(Table, not(isblank([objective]) )),[campaign_id])

mahoneypat
Employee
Employee

Are you sure it is blank and not a space or other character?  If so, please try DISTINCT(campaign_id[objective]) instead.  It will exclude the blank row.

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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