Forum Discussion
Create filtered measure with data from ssas
Hello every one, I created a report which get the live data from ssas, and i tried to create calculated measuer in ssas using this code (SUM([Measures].[Budget]) ,[JE Type].[JE Type].&[CI],[JE Typ...
Hi Abdalmoamen,
Try the following code for the DAX Measure:
Sales_SUM =
CALCULATE (
[Budget];
Table[JE Type] IN { "CI"; "NR" };
Table[Account Type] IN { "Cash"; "Bank"; "NotesReceivable" }
)Regards,
MFelix
Can't create this measuer in ssas cube
- Create this measure on your report direclty.
Can't create any measuer under live query mode
