CountA add condition

[GAPER]

Here is the formula powerBI suggested - How do I condition that only selecting unrealised_value_usd > 0?

Basically i wanna return the count of Pure_Project_id where the column unrealised_value_usd >0

To be exact

I would like to return Count of Project for each project based on how many "Unrealised_Value_USD" that's >0. Obviously the formula I have here is wrong. (the first few Project has the same Name but a different Count of Project)

Count of Project =

CALCULATE(

    COUNTA(DIM_Project[PROJECT]),

    ALLSELECTED('FACT_Holdings'[UNREALIZED_VALUE_USD] )

)

Thanks. 

[Anonymous · Accepted solution]

Hi @GAPER ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

DIM_Project table:

FACT_Holdings table:

1.Create measure

Count of Project =
CALCULATE (
    CALCULATE (
        COUNTA ( DIM_Project[PROJECT] ),
        FILTER ( FACT_Holdings, FACT_Holdings[UNREALIZED_VALUE_USD] > 0 )
    ),
    ALLSELECTED ( 'FACT_Holdings'[UNREALIZED_VALUE_USD] )
)

2.Final output

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[qqqqqwwwweeerrr]

Hi @GAPER 

Can you check this solution https://community.fabric.microsoft.com/t5/Desktop/Product-Counts-Based-on-Measure-Values/m-p/3618735... which is similar to you case if not please provide more details

Regards