Forum Discussion

ALHU's avatar
ALHU
Frequent Visitor
2 years ago

Matrix showing wrong aggregation per year

Hello i have the following measure that counts employees over time specificed by a date table:   Nr of Employees = CALCULATE(     COUNTROWS('masterdata hr_data'),     FILTER(         FILT...
Need Help
ALHU's avatar
ALHU
Frequent Visitor
2 years ago

This is what my matrix looks like:

 

and this is my drill-down in 2023 which is correct:

 

 

 

 

 

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi ALHU 

Can you please share sample data or pbix file (after removed sensitive data)