Need Help with DAX!!

[Debsidrian]

I am not getting the correct calculation out of DAX.

 Right number should be 107,568

Dc Count = DISTINCTCOUNT(Query1[Dc_nbr])

Damage Cases average per Dc_nbr =

AVERAGEX(

    KEEPFILTERS(VALUES('Query1'[Dc_nbr])),

    CALCULATE(SUM('Query1'[Damage Cases]))

)

Dc Count x Damage Cases average per Dc_nbr =

[Dc Count] * [Damage Cases average per Dc_nbr]

[Debsidrian]

File: VODC V1.1.pbix (Page 1 tab)

[Ashish_Mathur]

Hi,

Your formulas are fine.  You just need to remove the filter from the Top 5 condition from the "Damaged cases average per DC_nbr" card visual

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Debsidrian]

@parry2k @amitchandak