Matrix Table count

[kjshah5030]

Hello Everyone,

I am a new to power BI , I have a matrix table , which is given below image

so , the my question is how can I get count of Banchmark End Weight value is gretter then 10 
I tried but i m not getting proper ,
and also remember that this is matrix table , both values are coming from different table.
can any one help me ?

[v-yulgu-msft · Accepted solution]

Hi @kjshah5030,

Since both values are coming from different table, there existing relationship between two tables, right? If so, you could new a measure similar to:

CountValue =
CALCULATE (
    DISTINCTCOUNT ( table1[GICS Level] ),
    FILTER ( ALL ( table1 ), [Banchmark End Weight] >= 10 )
)

For more advice, please provide sample data and desired result.

Regards,

Yuliana Gu

[kjshah5030]

Hi @v-yulgu-msft Thanks for kind reply
I got my answer as I expected Thank you very much .