Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have millions for records in Sales table and we never use these Transaction level data in these reports. Always aggregate data.
Step 1: So I've created a Aggregate table using SUMMERIZE function and its working, seeing data, and report also looks good.
step 2. Added a filter using CalculateTable(): and this is also working, seeing data on the report as expected.
CALCULATETABLE ( SUMMERIZE (SalesFact,......), FILTER(SalesFact,...))
Step 3. I have another table and am trying to combine this table into above summerize table. So, am using Union as below:
UNION( CALCULATETABLE ( SUMMERIZE (SalesFact,......), FILTER(SalesFact,...)) , SUMMERIZE(SalesFactTable2,...)
When am done with creating this new table, am seeing data in the Data view. But am not able to see any data on the report.
and also I completely created new page to test, just pulled Total Sales onto the report and no data. but when I remove UNION part in the above DAX it's working.
Really appreciate help.
Solved! Go to Solution.
Hi @Anonymous ,
You may considerate the limitations of UNION function:
By my test using the functions and formula above to reproduce your scenario, it works well. You may upgrade the Power BI Desktop to the latest version 2.74.5619.862, and try it again.
You can download my test pbix from here.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You may considerate the limitations of UNION function:
By my test using the functions and formula above to reproduce your scenario, it works well. You may upgrade the Power BI Desktop to the latest version 2.74.5619.862, and try it again.
You can download my test pbix from here.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, @v-xicai based on your suggestion I've created a view in the database outside Power BI for summerized data (from both tables) and using this view as Source. Now I just have 5000 rows from 20 million rows.
For these reports I dont need indiivdual transactions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |