Forum Discussion

SelflearningBi's avatar
SelflearningBi
Helper III
3 years ago
Solved

COUNT NOT BLANK

MODEL NAME ON TIME? A YES B   C NO D NO I would like to see how many % on time is YES.   The calcuation should look like this 1/3=33% I dont want to include the blank B in ...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Yes percentage measure: =
VAR _yes =
    COUNTROWS ( FILTER ( Data, Data[ON TIME?] = "YES" ) )
VAR _allcountwithoutblank =
    COUNTROWS ( FILTER ( Data, Data[ON TIME?] <> BLANK () ) )
RETURN
    DIVIDE ( _yes, _allcountwithoutblank )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Yes percentage measure: =
VAR _yes =
    COUNTROWS ( FILTER ( Data, Data[ON TIME?] = "YES" ) )
VAR _allcountwithoutblank =
    COUNTROWS ( FILTER ( Data, Data[ON TIME?] <> BLANK () ) )
RETURN
    DIVIDE ( _yes, _allcountwithoutblank )