How to compute Brand by SOURCE ?

Question

HI All&nbsp;parry2k&nbsp;help me with the below post :-&nbsp;https://community.powerbi.com/t5/Desktop/How-to-use-DAX-expression-to-count-number-of-brand-sales-gt-100K/td-p/2262931&nbsp;Now i manage to compute SOURCE = TA Total have 10 Brand.&nbsp;Now i also know that SOURCE = TP total have 8 Brand :-May i know how can i get the summary report like below :-&nbsp;Below link is my PBI sample file :-https://www.dropbox.com/s/c4d4uxcpoiaizyb/PBTI_V023%20source%20by%20brand.pbix?dl=0&nbsp;Hope spme one can share with me.&nbsp;Paul

smpa01 · Answer

admin11&nbsp; you can simply use this
Measure = CALCULATE(DISTINCTCOUNT(SALES_T[BRAND_C]),ALLEXCEPT(SALES_T,SALES_T[SOURCE]))
&nbsp;

&nbsp;

jihwan_kim · Answer

Hi,
Please check the below picture.
&nbsp;

&nbsp;
Brand Rank Count: =CALCULATE (COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) ),FILTER ( SALES_T, SALES_T[SOURCE] IN { "TA", "TP" } ))

parry2k · Answer

admin11&nbsp;I think it should be a simple unique values of brand count per source
&nbsp;
Measure = COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) )

✨ Follow us on LinkedIn and subscribe to our YouTube channel
&nbsp;
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation! 
&nbsp;
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

&nbsp;

parry2k · Answer

Jihwan_Kim&nbsp; good solution if you want to filter on these two sources but using&nbsp;FILTER is not recommended since it is an iterator it will be very slow when working with large data. Just my 2 cents. The measure should look like this:
&nbsp;
Brand Rank Count: =
CALCULATE (
COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) ),
SALES_T[SOURCE] IN { "TA", "TP" }
)

&nbsp;

admin11 · Answer

parry2k&nbsp;I use your expression , every row return 11 ?Where i go wrong ? Can you pls share with me.&nbsp;Paul

Forum Discussion

How to compute Brand by SOURCE ?

10 Replies

✨ Follow us on LinkedIn and subscribe to our YouTube channel

✨ Follow us on LinkedIn and subscribe to our YouTube channel

✨ Follow us on LinkedIn and subscribe to our YouTube channel

Related content

Workspace Monitoring - compute costs ?

Your Compute session is disconnected

Data source

Building a brand new Power BI environment

Compute live pool schedule