Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.I need this type of end result.
I shall be very thankfull for any help.
Regards
@Amit Chandak
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |