Forum Discussion

sarthsla's avatar
sarthsla
Frequent Visitor
6 months ago
Solved

Count as per Area

Hi All, I have below data in Table Visual in PBI desktop, where StatusMeasure is generated dynamically based on ID and few conditions No when I want to count the Distinct IDs for each Area an...
Need Help
  • sarthsla's avatar
    sarthsla
    6 months ago

    Thanks I resolved it by myself with help of DAX using KEEEPFILTERS

GeraldGEmerick's avatar
GeraldGEmerick
Super User
6 months ago

sarthsla To do this, you generally need to use a table with no relationships that has a row for every potential value of your measure. You use that in your legend and then write DAX similar to the following for the distinct count:

 

StatusMeasure Count =
VAR _Legend = MAX( 'Legend Values'[Value] ) // this is your table with no relationships Yes/No
VAR _Table = DISTINCT( SELECTCOLUMNS( FILTER( ADDCOLUMNS( 'Table', "Status Measure", [StatusMeasure] ), [Status Measure] = _Legend ), "ID", [ID] ) )
VAR _Return = COUNTROWS( _Table )
RETURN _Return

 

sarthsla's avatar
sarthsla
Frequent Visitor
6 months ago

its showing all counts of IDS but not distinct counts for area

  • v-tejrama's avatar
    v-tejrama
    Community Support
    6 months ago

    Hi sarthsla ,


    Thank you cengizhanarslan  for the response provided!

    Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Thank you.

    • v-tejrama's avatar
      v-tejrama
      Community Support
      6 months ago

      Hi sarthsla ,

       

      I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

      Thank you.