Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Wrong output with specific filter

Hi everyone,   I'm rather new to Power BI and I just came across a weird error. When I filter a Card visual that sums up a number of times an event has happened, it always shows the correct value ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous I'm really confused. If you don't want to count those blank rows then you can do absolutely nothing. If you want to count those blank rows, then:

     

    CALCULATE(COUNTA(Addresses[Date of Appointment]), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date])) + CALCULATE(COUNTBLANK(Addresses[Date of Appointment]), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date]))

    or:

    CALCULATE(COUNTROWS(Addresses), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date]))

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler 

Unfortunately I can not look into the dataset at the moment. But If that was the case, can I rewrite the measure in any way so it ignores blank rows?

 

I've tried this and it doesn't solve the issue:

 

CALCULATE(count(Addresses[Date of Appointment]), NOT(ISBLANK(Addresses[Date of Appointment])), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date]))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Well, the measure is already ignoring blank rows. COUNTA doesn't count blanks. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Greg_Deckler 

    I just checked and the Date of Appointments in Addresses has some empty rows. Any ideas on what to try now?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous I'm really confused. If you don't want to count those blank rows then you can do absolutely nothing. If you want to count those blank rows, then:

       

      CALCULATE(COUNTA(Addresses[Date of Appointment]), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date])) + CALCULATE(COUNTBLANK(Addresses[Date of Appointment]), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date]))

      or:

      CALCULATE(COUNTROWS(Addresses), USERELATIONSHIP(Addresses[Date of Appointment], 'Date'[Date]))