Count Issue

[sharif]

Hi,

I have a table as below

Senario:: 

 I have a table where Plan Id is unique combination of account_name,brand_name & period. we need a count of plan_Id column in the same table by grouping remaining columns i.e account_name,brand_name & period.

Thank you.

[amitchandak]

Not sure I got it completely.

But you need category total then refer

https://community.powerbi.com/t5/Desktop/Calculating-percentage-of-a-subcategory-related-to-total-co...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Nathaniel_C]

Hi @sharif 
Not sure I understand, if you have a Plan_ID column, why not count the unique values in that column?
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[sharif]

Thank you Nathaniel_C,

here my issue is when i include Plan_id[Row_id from base table] always has unquie values. so i am not getting result.

Requirement is :: count of Plan id's group by account name, brand name and period. Hope this is clear.

Thanks,

Sharif

[Nathaniel_C]

Number of IDs by Account Name =
CALCULATE (
    COUNTROWS ( myTable ),
    ALLEXCEPT ( myTable, myTable[ACCOUNT_NAME] )
)

Hi @sharif ,
Try the code above, and create other measures just changing the column name to the other columns.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[sharif]

Hi @Nathaniel_C ,

Please find the below screen for your reference,

we need to bring PLAN_ID to this report, when we append PLAN_ID, records getting unique. Hence PLANCOUNT becomes 1 and visual level filter false. 

Thanks,

Sharif. 

[dax · Accepted solution]

Hi sharif, 

You could refer to my sample to see whether it work or not.

Best Regards,
Zoe Zhi

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

[sharif]

Hi Zoe Zhi,

Thanks for the solution it works 😊.

Regards,

Sharif.