Power bi - Count values once

Hi ChahindaAlyy ,

  Thank you for your question. I don't have a clear idea of what you're trying to accomplish. But I wrote a dax the way I understand it.

create  a measure：

Unique 1M =

CALCULATE (

    DISTINCTCOUNT ( 'TableName'[Solution Name] ),

    'TableName'[Solution Name] = "1M"

)

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If  i have misunderstood your meaning,  please provide more details with your desired out put and pbix file without privacy information.

 

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}