% of Total different in function of visual

[julrua]

Hello, 

I have 2 visuals (table & matrix). 

In the table, the measure Consumed(%) testbis is correct but not in the matrix table (cf. image). 

The 2 measures YTD Actual amount & Consumed(%) testbis are cumulative. 

Please find the measures below: 

YTD Actual amount = TOTALYTD(SUM('Business management (customer HUB)'[Actual amount]),'Business management (customer HUB)'[Date])

Consumed(%) testbis = DIVIDE([YTD Actual amount],calculate(SUM('Business management (customer HUB)'[Offer amount approved]),allselected()))

In the matrix table in the red rectangle I sould obtain 6,88% and not 0,70%. 

Thank you in advance 🙂 

[Icey]

Hi @julrua ,

I can't reproduce your issue. Could you share me a sample .pbix file with the same issue for test? Please remove sensitive information and real data.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[julrua]

Hi @Icey , 

Thank you for your reply. 

Please find the access to the Power BI: https://drive.google.com/drive/folders/1gMYsgJ1IUyjByMl1Yf6G8yPWQ4y5vDZT?usp=sharing

However, I am not able to reproduce the case. My YTD measures is not working.... Would it be possible to help me? 

Thank you in advance. 

Kind regards, 

[Icey]

Hi @julrua ,

This didn't reproduce the issue. It works well as what I create previously.

My repro:

Could you try to re-create the Matrix visual in your .pbix file or a new .pbix file? Sometimes there may be some intermittent issues.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.