Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
I have two source data table , Cost and Budget. And several mapping table related to this two source data as 1 to many.
And I design a table to display using the mapped field as row and measure as value. CC , H2 , H4 (all from mapping table for using using same slicer to filter Cost measure and Budget Measrue in one combined table.) as the row and budget as the value.
But the wired thing is , when I tried to display the budget in the table , it only displays the catogory which is existing in Cost table.
For Example,
The total is correct. But the category list missed the ones which have no cost this year. And it should have budget. Total 528 , and the total of displayed category is 500 , 28 missed is belonging to the missed one category.
Here is my DAX of measure,
I find the cause of this issue. When I delete the below code in DAX, and set the calendar date as a fixed date. It works. All the values appeared.
Hi @Anonymous ,
Due to the multiple tables in your sample, I can't make the problem clear. Can you please share some sample data and expected results? If okay, it is better to share a dummy pbix file that we can test.
Hi @v-xuding-msft ,
I'm not sure if I can make an example. It's so complicated.
As I mentioned , I have two source table , cost and budget , and several mapping table link to the two sources tables with one to many relationship. What I expect is to mix the measurement from this two tables to one table by using same row level.
For example , when the measure is below. (same for Act Y-2 , Y-3) . FBL3N is the source cost table.
But when the measure is
The value looks like below. all the value appear correctly.
VAR LastDateFromFact = MAX( FBL3N[date] ) is to get the lastest updated date in cost table. then we can know what's the current year or current date.
But seems if I use the max function , the calculation will run , but it will decide not to display if there is no value for the specific row level.
And we can't use now() to get the date because we still need to generate Dec report when it's Jan of next year.
Hope i have clarify the issue clearly.
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |