Forum Discussion

BrianMullen's avatar
BrianMullen
Frequent Visitor
2 years ago
Solved

Help with Count

Hi, I am trying to create a score card to count of how many machines hit the target of 85%   The table on the right shows the Score % each machine has got, this is made up of runtime/downtime over ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BrianMullen ,

     

    We can create a new measure [New At Target] to be placed on the visual object instead of the previous measure [At Target].

    New At Target = SUMX(VALUES('Table'[Machine]),[At Target])

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

  • BrianMullen's avatar
    BrianMullen
    2 years ago

    Hi All,

     

    Sorry for late reply i could not get the count to work in a card however i created a table and formatted to look like a score card

     

    Score Counter = IF(COUNTROWS(VALUES(Mtable[Machine]))=1,
    [Availability],
    (SUMX(VALUES(Mtable[Machine]),
    IF([Availability]>0.85,1,0))))
     

     

ValtteriN's avatar
ValtteriN
Community Champion
2 years ago

Hi,

Here is one way to do this:

Data:

 

Dax:

Test for 85 = SUMX('Table (22)',IF('Table (22)'[Value]>=0.85,1,0))


End result:

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • BrianMullen's avatar
    BrianMullen
    Frequent Visitor
    2 years ago

    Thanks for the suggestion but it has not produced the count, it shows 163672