Calculate in measure at column won't filter other objects
Hi! I placed this measure in "values" on a Matrix: measure = CALCULATE(sum(Fact[Totalsum]),Fact[type] = "D") But when i select anything within this matrix it will filter all objects from the model excluding Fact[type] = "D" and showing the absolute total (Measure total is selected) I also tried using SumX but didn't work: measure = SUMX(FILTER(Fact,Fact[type] = "D"),Fact[Totalsum]) Why could this be?
Creating relationship between two tables using null calculated columns SSAS
Hi! I'm having a problem of recreating a solution that my previous colleage did and nobody has no idea what the solution really means. There are two tables in tabular model: a dimension (D) and a fact table (F) which have the same source but each table contains different number of attributes. Each table contains a calculated column "Link" which has no expression: These two tables has a relationship (Many to one, Both Directions) using these two calculated columns: How does it even work? Even though I don't understand the logic, I tried to recreate this solution using another two tables, but I'm getting an error: Link column contains a duplicate value null and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Can somebody please explain what is going on and why am I getting an error while trying to recreate almost the same thing that actually works? Thank you in advance!Valor Máximo en Columnas Calculada.
Estoy creando una columna calculada con DAX en un modelo tabular para encontrar el valor maximo en la filas Ejemplo: Logre, encontrar el valor por columnas, pero necesito encotrar las columnas de forma dinamica, ¿alguna segerencia? Esta es la medida de Dax, que estoy usando: = MAXX( VALUES(SaldoSafix_MoraMaxima[cedula]), CALCULATE( MAXX( (SaldoSafix_MoraMaxima), CALCULATE( MAX(SaldoSafix_MoraMaxima[2021-6]) ) ) ) ) GraciasFastest way Use analysis service dataset as dataset table in oracle
Hello... Ssas technolgy is a great technlogy for one click to build a report as self service that can drag a measure with 2 or 3 diminsions and here you got your report... What is the fastest way to read a dataset built by ssas self service to load its result to a table in oracle database and use it later on as a datasource instead of build an oracle query from scratch until it matchs the result built by ssas... Is there any tobic or tool i can use?
Problem with Variation measure
Hello everyone. I have a Date table called Dim_Date2 and it doesn't connected to my Fact table Sales for others reasons. So, I have to filter date in each measure. I have the next measure to calculate Sales and Previous Sales: Sales:=CALCULATE(SUM(Fact_Sales[SalesAmount]), FILTER(Fact_Sales,Fact_Sales[SalesDate]>=[MinimumDate]&&Fact_Sales[SalesDate]<=[MaximumDate])) Previous Sales:=CALCULATE(Fact_Sales[Sales],DATEADD(Dim_Date2[Date],-[SelectedDays],DAY)) MaximumDate:MAX(Dim_Date2[Date]) MinimumDate:MIN(Dim_Date2[Date]) SelectedDays:CALCULATE(DISTINCTCOUNT(Fact_Sales[KeySalesDate]),FILTER(Fact_Sales,Fact_Sales[SalesDate]>=[MinimumDate]&&Fact_Sales[SalesDate]<=[MaximumDate])) And the variation is the subtraction of both. Previous Sales measure works if I select an specific date, but if I select the same date with a Year, month and day... it doesn't work . I hope you can help me.
[SSAS] Measure := IF [column1] = "ABCD" then DIVIDE()... else... DIVIDE()
Hey everyone, I have a IF condition that I need to replicate in DAX measure. It looks like that: Measure := IF [column1] = 'Y' then DIVIDE(sum([col2),sum(col2)+sum(col3)) else DIVIDE(sum([col2]),sum[col2]). Else condition of course can be hardcoded as "1" but that's not a main issue here. As we know, DAX measures can't use IFs based on Columns in the model/data so what would be the best way of implementing this in DAX measure(!) [this is important as I'm working with SSAS not PBI]?
