Forum Discussion
Solved
Distinctcount based on values in another column of same table – DAX for measure?
Hello Experts, I am new to Power BI. Could you please help me with below? So below is my simplified table resource_name | scan_date | Scan_time | server selected | ABS ...
Hi Meraki_jeet your measure for distinctcount should be something like: DISTINCTCOUNT(Table[ColumnName]), so as I understand from your example it should be DISTINCTCOUNT(YourTableName[resource_name]), as resource_name is only column with 2 distinct value. i hope this help.
Hi some_bih , Thanks alot! I was able to get the above requirement with below formula,
Calculate(Distinctcount(TableName[resource_name]), ALLEXPECT(TableName, TableName[scan_date], TableName[Scan_time], TableName[server selected]))