Forum Discussion

jostnachs's avatar
jostnachs
Helper IV
1 year ago
Solved

Calculated column groupby

  Hi All... I have a requirement where i have to add column in one of the tables where i have to find the count of prbrnames grouped for each policy id. Policyid is in policy table and Prbrnames are...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, jostnachs 

    Based on your information, I create sample tables:

    Policy Table

    Producer Broker Table

    Production Table

     

    Then create a new calculated column, try the following DAX expression:

    PolicyShareStatus1 = 
CALCULATE (
    COUNT ( 'Producer Broker'[PrBrName] ),
    FILTER (
        ALL ( 'Producer Broker' ),
        'Producer Broker'[PolicyID] = EARLIER ( 'Policy'[PolicyID])
    )
)

     

    Here is my preview:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jostnachs's avatar
jostnachs
Helper IV
1 year ago

Still no luck....gives me the same result as it gave me previously

 

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523