KPI not updated with slicer

[o59393]

hi all

I created a dax metric to calculate the % of projects on high risk, medium risk and low risk out of the total.

I had created a second table that summarizes that groups several countries in regions, for example, Costa Rica, Nicaragua and Guatemala are Central America. The 2 tables are in a one to many relantionships correctly set up.

The problem is with the dax metric created. When I select a region, the table will still reflect all the country's projects and not the selected region. Basically the slicers dont modify the table. So I think the dax is missing some sort of filter.

The function is

Original dashboard, without slicers activated:

Dashboard with region slicer on, table will still reflect all non central american countries.

Appreciate the help.

[Icey]

Hi @o59393 ,

Sorry, I can't reproduce your issue. How do you create the matrix visual? Please create a PBIX file with the data you give me.

Best Regards,

Icey

[Icey]

Hi @o59393 ,

If you don't mind, please give me some data sample or PBIX file without privacy information by Dropbox, OneDrive, GoogleDrive, etc, and attach the link.

Best Regards,
Icey

[o59393]

hi icey!

will the raw data be fine?

https://www.mediafire.com/file/ipnnoa6ng49gsx6/query_%288%29.xlsx/file

Please let me know, I am starting my journey in this community.

Thanks a mill for the help!

[Icey]

Hi @o59393 ,

Is this problem solved?

Best Regards,

Icey