The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello all,
I'm fairly new to Power BI and have run into a problem that I hope someone can help me with please?
I have Table A which is an unrelated table of data:
From | To | Bonus |
3.25 | 3.30 | 0.15 |
3.30 | 3.35 | 0.3 |
3.35 | 3.40 | 0.45 |
I have a matrix table showing columns of month end dates, with varying rows of information underneath gathered through other measures and table data:
I have filtered the table to show month end dates from January to May 2024, but since adding a Measure, I now have columns from Aug 23 to July 24, the full date range of my data.
The code I've used for my measure is:
Solved! Go to Solution.
It's easy when you know how, ha!
A very simple solution to the problem was to simply wrap an IF statement around the measure, to check whether a value was present e.g.:
It's easy when you know how, ha!
A very simple solution to the problem was to simply wrap an IF statement around the measure, to check whether a value was present e.g.:
Hi @AliPoTD ,
Thanks for the reply from @amitchandak , please allow me to provide another insight:
This may have something to do with the relationships between your data tables. You need to make sure that you have defined the relationships between your tables correctly. Typically, you have a one-to-many relationship between your date and fact tables. Also, check the filter direction of the relationship. If Protein Bonus is an unrelated table, the measure may not be applying the filter correctly.
If this doesn't solve your problem, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. problem and help you.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@AliPoTD , Based on what I got
This will work like
Hi, thanks for the advice, but this hasn't worked 😞
I get a syntax error due to filtering on a VAR value, see image:
I have changed the code to the following so that it is drawing directly from the unrelated table, but I end up with the same initial error: