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.
some_bih
Community Champion
Community ChampionHi 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.