Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Card display the same total as table

Hello   This must be a simple question but I'm not able to do it.   I have a table that as the following values: ID summary Count(occurences>1) 1 a               3 2 b               2 3 c    ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

vanessafvg,

 

If you look at the image the table displays the values as expected but the card does not. It shows all the ocurrences, and not the filtered total (ocurrences >1).

 

What I want is to display the total in a card (379 in this case).

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

Anonymous

 

ok try this

 

 

measure = CALCULATE(COUNTROWS(Table), FILTER(Table2, COUNTROWS(Table) > 1) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vanessafvg

     

    :( it continues to gve the total.

     

    I Thisn that coutrows gives the number of rows bigger than 1 which in this case are all. They are not grouped by, so In fact I have "just" ones on the part I need to add.

     

    My table is like a mapping table, so what I have are entries that give me the destination x and the entry point, y,z,t...

     

    What I find peculiar is that the table gives me the correct total, but I can not get that by other means...

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    Anonymous  i also want to figure out how to do this, the problem is with the total becasue if you do it individually it works

     

     

    this was my test.

     

    i posted a question on sqlbi and those guys always respond with the best answer so will get back to you

  • Thyago_Rezende's avatar
    Thyago_Rezende
    Resolver I
    8 years ago

    Hi,

     

    Display your data model and target table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks vanessafvg, they are indeed experts. :)

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-huizhn-msftTill this moment I could not solve it.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Please set the is greater than 1 in Page level filters(highlighted in yellow background) rather than Visual level filters. 



    Best Regards,
    Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-huizhn-msft

     

    It does no work because in fact the Visual Level Filter is "count of field is >1" and in the Page level I can not add the "count" part

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Yes, we can not use measure in page filter level after test.

    Best Regards,
    Angelia