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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Usman6400
Frequent Visitor

Attribute Function From Tableau to Power bi.

Hi Community, 

I have a scenario in which I am replecating ATTR() Function of Tableau into power bi. I am using this measure 

 

 

 

ATTR = VAR _dist = DISTINCTCOUNT('PAC Resanction Query'[Old PACs Filter])
return
IF(_dist > 1, "*", [_m_No. Of Resanctioned PACs])

 

And getting this below result that is fine. But the problem is I have 2 sub categories 0 and 1. and I just wanted 1's result. pic2.PNG
This is the 0 and 1. Where we have 2 values I need * but where 0 is single I dont need that value. If 1 is single I need that value.
PIC3.PNGI need this type of end result.

PIC1.PNGI shall be very thankfull for any help.

Regards

@Amit Chandak

2 REPLIES 2
Usman6400
Frequent Visitor

@Jihwan_Kim 
Could you please look into it.

Anonymous
Not applicable

HI @Usman6400,

You can take a look at the following blog to know how to use filters to check current row context levels, then you can use the if statement with conditions to check records count values and replace them with different results.

Clever Hierarchy Handling in DAX - SQLBI

If you are confused about the coding formula, please share some dummy data to test:

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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