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
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

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