The difference between a derived measure and a calculated measure is when the calculation is performed. A derived measure is calculated before aggregations are created, and the values of the derived measure are stored in the cube. A calculated measure is calculated after aggregations are created, and the values of a calculated measure aren’t stored in the cube. The primary criterion for choosing between a derived measure and a calculated measure is not efficiency, but accuracy.
Subscribe to:
Post Comments (Atom)
Search This Blog
DAX - Grouping on multiple columns and the count
Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or full...
-
SSRS 2008 R2 allows us to execute reports in 3 modes: 1. On Demand. 2. From Cache 3. From Snapshots On demand: This is normal approach tha...
-
---Fibonacci numbers declare @fib table(fib_id bigint,fib_val bigint) declare @current_val bigint,@previous_val bigint,@new_val bigint in...
No comments:
Post a Comment