Forum Discussion

Abdalmoamen's avatar
Abdalmoamen
Frequent Visitor
8 years ago

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 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")

 

Need Help
Tips and Tricks
Tutorial Requests

6 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    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

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        8 years ago
        Create this measure on your report direclty.
  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    8 years ago
    Hey,

    currently it's not possible to create measures from within Power BI on top of SSAS Multidimensional (SSAS Cube).

    The creation of additional measures is just supported for SSAS Tabular.

    Regards
    Tom
    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      8 years ago
      Hi Tom,

      Not on my computer right now but i have a SSAS Multidimensional cube that i was abble to do measures on I believe that this depend on the version.however I will check if it is a multidimensional, i'm sure about the.live connection on it.

      Regards,
      MFelix