Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    If you want to use measure and matrix, you can create this measure:

    alert_count =
COUNT ( store_loc[emp_id] ) - 1

    Put 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.

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous add following measure and then use it in visual left filter

 

Count = COUNTROWS ( Table ) - 1

 

add a table visual, put store number and this new measure and in visual left filter choose where count > 1

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡