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])
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.