Forum Discussion
Count in SQL to DAX
I am able to get a count in SQL. Trying to do the same with DAX measure is not resulting in the correct output. How would you translate the following: SELECT store_num, COUNT(emp_id)-1 AS alert_co...
Hi Anonymous ,
If you want to use measure and matrix, you can create this measure:
alert_count = COUNT ( store_loc[emp_id] ) - 1Put it in Matrix, and create another measure like this, set its value as 1 and put it in the visual filter:
visual control = IF ( [alert_count] > 1, 1, 0 )If you do not want to use this filter measure, you can filter it directly by [alert_count]:
Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Share some data, describe the question and show the expected result.