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])
                    )
v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Thank you FBergamaschi , mdaatifraza5556 , and AmiraBedh  for your responses.

Hi radissoufan,

Thank you for your update and for sharing your insights and approach to resolving the issue. Kindly continue to utilise the Fabric Community for any further assistance with your queries.

Thank you.