How to construct a dynamic Coefficient of Variation in PowerBI Desktop?

[KimmoS]

Hello!
I guess I am not the first one with problem like this but I really get no further than getting the constant value which is based on the whole dataset DRG_data. There are something like 3M rows and Cost has no null values and only some zeroes. There are some slicers but after slicing there still are quite big subgroups.

How to fix my code? Any advice is helpful.

CoefVariation =
VAR SelectedCost = VALUES('DRG_data'[Cost])
VAR FilteredTable = CALCULATETABLE('DRG_data', 'DRG_vertailu'[Cost] IN SelectedCost)
VAR MeanKustannus = AVERAGE('DRG_data'[Cost])
VAR StdDevKustannus = STDEV.S('DRG_data'[Cost])
RETURN
IF(
ISBLANK(MeanCost) || MeanCost = 0 || StdDevCost = 0,
BLANK(),
DIVIDE(StdDevKustannus, ABS(MeanKustannus)) * 100
)

With Regards,
Kimmo

[KimmoS]

Thank you for your answer.

I would like to send the link, but data belongs to a customer, so I am not able to share it. Could you propose a link to a web page etc... where somebody has had same kind of issues? My problem is that somehow filtering only has effect on visualisation.

Can I somehow refer to Tab where my visaulisation is or is there a way?

With Regards,
Kimmo Sivonen

[Fowmy]

@KimmoS 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.