Forum Discussion

mahmoud's avatar
mahmoud
Helper I
5 years ago
Solved

Count Retuned Values by a Measure

Hi All, 

Dear Anonymous 

Mr. yingyinr helped me to create a Measure to automatically calculate the active status of our participants. Thanks for your support!

In the following URL is the solution link, https://community.powerbi.com/t5/Desktop/Group-by-and-Conditions/m-p/1734027#M683555 

 

I have another table called Org_Type, has relation with Org_Tbl. What I am looking for now is, how to count number of active participants by type? Also, it is affected by same filter controls/visuals

Thanks for your support in advance!

Best Regards

Mahmoud

 

 

Need Help
  • mahmoud's avatar
    mahmoud
    5 years ago

    Hi Dears,

    I tried this solution (Create a Measure)and it worked. 

    Measure CountActive = 
COUNTROWS(
    FILTER(
        RELATEDTABLE(Org_Tbl),
        Org_Tbl[New measure for ActiveStatus] = "Active"
    )
)

     

    Thanks for your support

    Best Regards

    Mahmoud

     

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    mahmoud , You have try a measure like

     

    countx(values('Org_tbl'[Org_type]), if([Measure ActiveStatus] ="Active", [Org_type], blank()))

  • mahmoud's avatar
    mahmoud
    Helper I
    5 years ago

    Dear amitchandak 

    Thanks for your prompt response, I tried your suggestion, it did not give me the accurate figures. Where, as you see in the photo, it is give me incorrect figures with incorrect Types.

     

    I did a manual calculation, I have two types only and the total figure is 33 (11 for first and 22 for the second type).

     

    Best Regards

    Mahmoud

  • mahmoud's avatar
    mahmoud
    Helper I
    5 years ago

    Hi Dears,

    I tried this solution (Create a Measure)and it worked. 

    Measure CountActive = 
COUNTROWS(
    FILTER(
        RELATEDTABLE(Org_Tbl),
        Org_Tbl[New measure for ActiveStatus] = "Active"
    )
)

     

    Thanks for your support

    Best Regards

    Mahmoud