Forum Discussion

Mughees's avatar
Mughees
Helper II
5 years ago
Solved

Filtering blank rows through power query before applying IF command

Hi All,   I am making a dashboard that has got calculations. My scenario is this:   I have created a data set that has got different indicators and it is being represented for different hierarchi...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Mughees ,

     

    If your issue is with that COUNT in the numerator taking the blanks into account for the Tehsil measure, you could try this:

     

    COUNT () - COUNTBLANK()

     

    See below:

     

    Sample Table:

     

     

    Sample Matrix:

     

    Regards,

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Mughees ,

 

If your issue is with that COUNT in the numerator taking the blanks into account for the Tehsil measure, you could try this:

 

COUNT () - COUNTBLANK()

 

See below:

 

Sample Table:

 

 

Sample Matrix:

 

Regards,

 

  • Mughees's avatar
    Mughees
    Helper II
    5 years ago

    Thankyou. BTW i just applied counta and it resolved my issue preety quickly. thank you though