Forum Discussion

radissoufan's avatar
radissoufan
New Member
1 year ago
Solved

power bi function ALL strange behavior

Hello, I have single simple DAX Measure 2 = CALCULATE(     COUNTA(Query1[target_lfs_agg.f_m_id]),             ALL(Query1[target_lfs_agg.age_group])                 ) the result is s...
Need Help
  • radissoufan's avatar
    radissoufan
    1 year ago

    first one is

    Measure 2 = CALCULATE(
        COUNTA(Query1[target_lfs_agg.f_m_id]),
                ALL(Query1[target_lfs_agg.age_group])
                    )
    second one is

    Measure 2 = CALCULATE(
        COUNTA(Query1[target_lfs_agg.f_m_id]),
                ALL(Query1[target_lfs_agg.age_group_id])
                    )

    the strange thing is that the result of the first image finally gave me a correct result when i included the (id) column which i used in sorting the description column with the all() function 

    Measure 2 = CALCULATE(
        COUNTA(Query1[target_lfs_agg.f_m_id]),
                ALL(Query1[target_lfs_agg.age_group]),
                ALL(Query1[target_lfs_agg.age_group_id])
                    )
FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

You show two images

 

Can you please write here

 

The code executed in each and  what is the column grouped in the ROWS section in each?

 

ALL as a CALCULATE modifier removes filters so you should see the same value but that depends on which is the column on ehich you remove the filters vs which is the column you are grouping in ROWS

 

The behoaviour in the firts image seems incorrect at first glance, so please can you share the pbix via some cloud service

 

Thx

 

 

 

If this helped, please consider giving kudos and mark as a solution

mein replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI