Forum Discussion
Need Help with DAX!!
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]
4 Replies
Hi,
Share the download link of the PBI file.
File: VODC V1.1.pbix (Page 1 tab)
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
