Forum Discussion

sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
6 years ago

Complex Dax Measure - Help Needed

Hello Folks,   I have a complex requirement in Power BI reporting which is sourced from Azure Analysis Services Tabluar Model via Live Connection. I cannot change the Tabular model, so the measure ...
DAX
Get Help
measure
sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
6 years ago

daxer-almighty  Thank you so much for helping me out,  I am unable to implement last section i.e. from "SelectColumns" my dax intellisense is not recognising it.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

If you can't use SELECTCOLUMNS, replace the corresponding bit of code with this:

var __customersSurvivedCount =
    calculate(
        countrows( Customer[CustID] ),
        __qualifiedSections,
        ALL( Transactions )
    )

My code returns the number of customers but you can easily change so that it returns the sum of transactions for the customers in question.