Forum Discussion

JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago
Solved

Column Calculation Exclude Blank Cells

I have measure working for a KPI = CALCULATE(AVERAGE('Table'[Section]),FILTER('Table','Table[Section]<>0))/5.16 This works as a DAX Measure. So as a measure this gives a return and works and exclud...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    JohnnyT48 
    Thank you for your replay .

    If you can't change the connection mode of your data from DirectQuery to Import mode, it's not a wise choice to create a calculate column, because after my test, most of the dax functions don't work in Direct Query connection mode so please check if your connection mode is Direct Query
    After my test, I was not able to use most of the functions in calculate column in this mode (Power BI doesn't prompt for the information)

    like this:( I can't even use the calculate function in calculate column with Direct Query mode )



    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago

Tried the cauclation same as you for the column and got the following message:

A circualr dependcy was detected.

This only happens when I apply the filter, if caculate avergae only without filter it works ok.

 

Thanks

Johnny

Anonymous's avatar
Anonymous
Not applicable
2 years ago

JohnnyT48 
Thank you for your replay .

If you can't change the connection mode of your data from DirectQuery to Import mode, it's not a wise choice to create a calculate column, because after my test, most of the dax functions don't work in Direct Query connection mode so please check if your connection mode is Direct Query
After my test, I was not able to use most of the functions in calculate column in this mode (Power BI doesn't prompt for the information)

like this:( I can't even use the calculate function in calculate column with Direct Query mode )



I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.