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.
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 06-06-2023 1:00:00 AM SQL
BCS 06-06-2023 1:00:00 AM SQL
ADB 08-06-2023 8:00:00 AM Oracle
So here i need to find out the concurrency issue. As above you can see for resource_name "ABS" & "BCS" the scan_date, scan_time and server_selected are same. So in this scenario i have to highlight this and expecting a output like below either as measure or calculated column.
output required:
Scan_date | Concurrent issue |
06-06-2023 2
So I have to take count of distinct resource_name which have all same details
Thanks in advance!!
Solved! Go to Solution.
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.
Proud to be a Super User!
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]))
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.
Proud to be a Super User!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |