Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Type].[JE Type].&[NR],[AccountType].[Account Type].&[Bank],[AccountType].[Account Type].&[Cash],[AccountType].[Account Type].&[NotesReceivable])
But i get this value as null, so there's any way to create this measuer in powerbi directly?
I want to sum all Budget Values from my fact measuers with the filter of:
1. [JE Type] dim = ("CI","NR)
2. [Account Type] dim = ("Cash","Bank","NotesReceivable")
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCan't create this measuer in ssas cube
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCan't create any measuer under live query mode
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |