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])
                    )
mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

Hi radissoufan 

I have tried with a sample dataset.

It's working fine.
Could you please share the PBIX file or the sample dataset?

Below is what I have tried.

Result = CALCULATE(
    COUNTA('Table'[f_m_id]),
    ALL('Table'[age_group])
)
 
 

 

I have also attached the pbix file you check it.


 



If this answers your questions, kindly accept it as a solution and give kudos.