Work with measure

[answeriver]

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.

[ibarrau · Accepted solution]

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,

[answeriver]

Thanks, work perfect