Forum Discussion

leoleoniids's avatar
leoleoniids
Frequent Visitor
5 years ago
Solved

Distinctcount based on measure values

Hi!   I am looking for solution to make a measure what in excel would be COUNTIFS.   How could I get card visual with counted rows what I can filter, but cannot make a simple number of rows.   ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, leoleoniids 

    I tried to create a sample pbix file based on the explanation.

    Please check the below picture and the sample pbix file's link down below.

     

     

    Img Count =
    VAR newtable =
    SUMMARIZE (
    'Product',
    'Product'[Product_id],
    'Product'[admin_creator_id],
    "@countimg", COUNTROWS ( FILTER ( img, COUNTROWS ( img ) >= 25 ) )
    )
    RETURN
    SUMX ( newtable, [@countimg] )
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, leoleoniids 

I tried to create a sample pbix file based on the explanation.

Please check the below picture and the sample pbix file's link down below.

 

 

Img Count =
VAR newtable =
SUMMARIZE (
'Product',
'Product'[Product_id],
'Product'[admin_creator_id],
"@countimg", COUNTROWS ( FILTER ( img, COUNTROWS ( img ) >= 25 ) )
)
RETURN
SUMX ( newtable, [@countimg] )
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

  • leoleoniids's avatar
    leoleoniids
    Frequent Visitor
    5 years ago

    Hello Jihwan,

    Thank you. I have changed SUMX to COUNTAX to count a number of products that contains more the 25pic