SSAS Connection_COUNTIF Measure

[Anonymous]

Hi,

I have a(n) SSAS model - Live connection - that i connect to and i need a column that would tell me if order contains some specific products.   Is there any way to do this with a New Measure? The live connection is very slow and import mode is just not working because of that.

[v-xulin-mstf]

Hi @Anonymous

It's not supported in power bi now, you can create measure in tabular model.

Please refer:

https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-6-create-measures?view=asallproducts-allversions

Best Regards,

Link

[FarhanAhmed · Accepted solution]

What is your SSAS model, is it tabular or multidimensional?

I believe you cannot enhance your SSAS live model on PBI Desktop.

you need to enhance the model at the SSAS level to capture the Values only if Products 1 & 2 are selected.