Count Retuned Values by a Measure

[mahmoud]

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

[mahmoud · Accepted solution]

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

[mahmoud]

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

[amitchandak]

@mahmoud , You have try a measure like

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