Forum Discussion

WDarwish's avatar
WDarwish
Frequent Visitor
6 years ago
Solved

Help with counting behavior

Apologies if the subject is not 100% clear - it is difficult to describe as English is not my native language.   I have a simplified data set that represents my problem. Also attached sample PBIX. ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    6 years ago

    WDarwish for card, add this following measure and you don't need visual level filter on card whcih you currently have.

     

    Invisible Count = 
CALCULATE( COUNTROWS( 'Sample' ), NOT 'Sample'[Is Visible?] )
  • parry2k's avatar
    parry2k
    6 years ago

    WDarwish Basically that measure is saying just ignore any filter on Is Visible  and just count where Is Visible is False

parry2k's avatar
parry2k
Super User
6 years ago

WDarwish for card, add this following measure and you don't need visual level filter on card whcih you currently have.

 

Invisible Count = 
CALCULATE( COUNTROWS( 'Sample' ), NOT 'Sample'[Is Visible?] )
WDarwish's avatar
WDarwish
Frequent Visitor
6 years ago

Is it really this simple? Are you a magician? :D

 

Seriously though, do you mind explaining the logic of how it works? I understand the individual functions used in the measure, but I do not understand how they combine to filter out data and count only rows of concern.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    WDarwish Basically that measure is saying just ignore any filter on Is Visible  and just count where Is Visible is False