Forum Discussion

abhiigt's avatar
abhiigt
Frequent Visitor
5 years ago
Solved

ALLEXCEPT DAX function not working

Hi,   I am using ALLEXCPET DAX function in the below sample formula :   Measure_Sample= calculate(count(city),ALLEXCEPT(citytable,updateddate))   and when I use updateddate in filter pane as a...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi abhiigt ,

     

    Here is one post which is similar with yours. Please check if it could help you.

     

     

    This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.

    Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

Icey's avatar
Icey
Community Support
5 years ago

Hi abhiigt ,

 

Here is one post which is similar with yours. Please check if it could help you.

 

 

This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.

Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.