Forum Discussion
divide 2 values
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
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
)
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