

Search
You searched for the word(s):
Showing page 1 of 104 (1,035 total posts)
< 1 second(s)

Maybe the problem is the FILTER ( COA, ... ) which is useless, you could write:
IF (
CALCULATE (
COUNTROWS ( VALUES ( COA[Heading2] ) ),
COA[Heading2] = "Retained Earnings (Current Year)"
)
= 1,
[Total Amount Net Income Current US FC],
...

Irma, a rounding error that accumulates is very strange. Are you able to repro this in Adventure Works? If not, I would suggest you opening an incident support case with Microsoft, submitting the model with the errors and helping them to find any bug. Keep me updated, thanks!

Irma  this seems to be another issue.
Do you see a difference in decimals or a completely different (or missing) number?

Irma, the problem is related to the implementation of RANKX: it builds a list of values and, when it looks for a value in order to get the index (the position), if the rounding error fails the match, the result is completely wrong.
The current workaround is to at least do the rounding to a money for the expression that applies the RANK (without ...

James,
I know that performance might suffer because of the implementation that is required in DAX. One of the possible optimizations is "precalculating" measures as calculated columns  if you can define such a column using the cardinality of tables you already have.
Other techniques might depend on the specific needs of your measures ...

If you work with MDX, using MDX Studio is a must, but it has not been updated for years. But community is great and Ihor Bobak has been able to apply two fixes: performance counters work with named instance and there is a single version regardless of the client libraries, so you have only one executable working with all available versions of ...

Consider using DAX Studio  you can run the same DAX Query on both Power Pivot and Tabular model
http://daxstudio.codeplex.com

Matt,
I don't see particular syntax issues. Are you sure that the 'View_Patient_With_SVF'[Elig_Annual] column has values that match with the DimDate[Date] column? If yes, are you sure that given a selection of DimDate (for a specific date), such a date exists in some rows of the fact table?
For example, if 'View_Patient_With_SVF'[Elig_Annual] ...

Since 2012 I have seen many companies adopting SQL Server Analysis Services Tabular as the analytical engine for their product or service. I think that this is still a fraction of the companies that might do the same choice. Why? Because… The features already existing in Tabular might be enough to justify its adoption as analytical engine. ...

If you extract data from Tabular into a Power Pivot tabular model, you have to edit the DAX Query for doing that.
If you are connecting a Pivot Table to a Tabular model, just apply a filter to the pivot table.
1 ...



