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 p...
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,

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,

  • answeriver's avatar
    answeriver
    Helper IV
    6 years ago

    Thanks, work perfect