divide 2 values

[Pri1nziii]

Hello,

Can someone please help me?
I have a table. Different times are being calculated here.
I have different filters: year, month, calendar week.

My problem is that I would like to divide two by two and then display them as a percentage.

Can someone help me with this?

How can I upload an example file?

Thanks everyone.

[v-hashadapu]

Hi @Pri1nziii , We are closing this thread as we haven't heard from you in a while, according to our follow-up policy. If you have any more questions, please start a new thread on the Microsoft Fabric Community Forum. We will be happy to assist you! Thank you for being part of the community!

[v-hashadapu]

Hi @Pri1nziii , it's been a while since we last heard from you. We are ready to assist you with resolving the issue, but we need the necessary details from you. Kindly share the information required so we can better understand and address your issue.

[v-hashadapu · Accepted solution]

Hi , Thank you for reaching out to the Microsoft Community Forum.

This can be due to the Calendar table not having a relationship with other table but can't say for sure. If possible, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

[Pri1nziii]

Hello

Thanks for the formula.

But now the problem is that my filters no longer "work."

The value no longer changes depending on the date.

Filters: Year, Month, Week of Calendar, Day

Maybe another idea?

Thanks

[rohit1991]

Hi @Pri1nziii ,

Here’s how to make sure your efficiency percentage updates correctly when you use your filters (year, month, week, etc.).

1. Create your measures (not columns!) It’s important to use DAX measures, since only measures react to slicers and filters. For example:

VC = SUM(Data[VC])
NC = SUM(Data[NC])
Efficiency (%) = DIVIDE([VC], [NC], 0)

2. Make sure your tables are related Your date/calendar table should be related to your main data table. Otherwise, slicers won’t filter your visuals as expected.

3. If the value isn’t changing with filters: Double-check that you’re using measures, not calculated columns. Check your relationships (Date, Year, Month, etc.) are set up and active. Try using ALLSELECTED if you have more complex filtering:

Efficiency (%) =
    DIVIDE(
        CALCULATE(SUM(Data[VC]), ALLSELECTED('Calendar')),
        CALCULATE(SUM(Data[NC]), ALLSELECTED('Calendar')),
        0
    )

[Pri1nziii]

Hello,

I need help.

Unfortunately, my filters aren't affecting my ads.

No matter what date is selected in my filters, my efficiency display remains unchanged.

VC = (Values[TARGET_TE] + Values[TARGET_TR])/60

NC = (Values[AGIST_TE] + Values[AGIST_TR])/60

Efficiency (%) =

DIVIDE(SUM([VC]),SUM([NC]),0)

How do I get my filters to work?

Thanks