Forum Discussion

answeriver's avatar
answeriver
Helper IV
6 years ago
Solved

Work with measure

Hi all,

Please help me in question.

I have two tables with data,

1. With data of plans by peoples

2. With data of facts by same people

Also have simple measure wich calculate % of achieving of plan. And all of this i using in visual table for view per man.

How i can count of people which achived plan in?

i try use: Calculate(count [Name]);%>=100%) , but it's not working.

Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi. It is a bit more tricky than that because you need the % to be calculated for each people in order to count them. Try something like this:

    = COUNTROWS (
    FILTER(
        ADDCOLUMNS(
            ALL(People[Name]), "@Percetenge", [Measure %]
        ),
    [@Percentege] > 1
    )
)

    First build your people and % table, then filter it and at the end count it. I think you should ask for > 1 and not 100 if you are using the % formatting.

     

    Hope this helps,

    Regards,

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi. It is a bit more tricky than that because you need the % to be calculated for each people in order to count them. Try something like this:

    = COUNTROWS (
    FILTER(
        ADDCOLUMNS(
            ALL(People[Name]), "@Percetenge", [Measure %]
        ),
    [@Percentege] > 1
    )
)

    First build your people and % table, then filter it and at the end count it. I think you should ask for > 1 and not 100 if you are using the % formatting.

     

    Hope this helps,

    Regards,