cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kjshah5030 Frequent Visitor
Frequent Visitor

Matrix Table count


Hello Everyone,

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

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 ?


1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Matrix Table count

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Matrix Table count

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kjshah5030 Frequent Visitor
Frequent Visitor

Re: Matrix Table count

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