Forum Discussion

Forrester's avatar
Forrester
New Member
8 years ago
Solved

dax fixed count

Hello,   I am trying to get a fixed count for accounts under a customer so that I can apply 1 of 2 billing models (measure A for customers with 1 account, measure B for customers with >1 account). ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Forrester,

    Problems:

    Calculated Column Method:

    If i create the #ofAccounts as a calculated column I am struggling to pull it into the billing measure:

    Example: Billing:=IF([#ofAccounts]>1,[Measure B],[Measure A]) --Problem I cant refence {#ofAccounts) because its not reference customer 

     

    Maybe you could try this formula:

    Billing=IF(MAX([#ofAccounts])>1,[Measure B],[Measure A])

    Best regards,

    Yuliana Gu