cancel
Showing results for
Did you mean:
Memorable Member

How to compute Brand by SOURCE ?

HI All

@parry2k help me with the below post :-

https://community.powerbi.com/t5/Desktop/How-to-use-DAX-expression-to-count-number-of-brand-sales-gt...

Now i manage to compute SOURCE = TA Total have 10 Brand.

Now i also know that SOURCE = TP total have 8 Brand :-

May i know how can i get the summary report like below :-

Below link is my PBI sample file :-

https://www.dropbox.com/s/c4d4uxcpoiaizyb/PBTI_V023%20source%20by%20brand.pbix?dl=0

Hope spme one can share with me.

Paul

10 REPLIES 10
Community Support

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

@admin11  you can simply use this

``Measure = CALCULATE(DISTINCTCOUNT(SALES_T[BRAND_C]),ALLEXCEPT(SALES_T,SALES_T[SOURCE]))``

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Super User

@admin11 that's not my measure, this is what I gave you, but you have something totally different:

``Measure = COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) )``

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  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!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Memorable Member

Yes , i just check , you give me the correct expression . now it working fine.

Can i have one more request , that is add one more condition , only count those brand sales >100K only.  As i want to focus on high sales  brand.

Paul

Super User

``````Measure =
SUMX (
SUMMARIZE (
SALES_T,
SALES_T[SOURCE],
SALES_T[BRAND_C],
"@Sales", [SALES_T] //replace SALES_T with the measure you want to check for the value
),
IF ( [@Sales] > 100000, 1 )
)

// COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) )``````

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  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!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Memorable Member

Appreciate very much for your effort. Thank you.

i have apply your expression in my PBI , i realise that the limit setting 100K is not filter at actual value. there are some error. not sure cause by what ?

PBI sample file :-

https://www.dropbox.com/s/wknx581wrrui4vy/PBS_VER0293.pbix?dl=0

Paul

Super User

@admin11 I think it should be a simple unique values of brand count per source

``Measure = COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) )``

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  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!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

Hi,

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

@Jihwan_Kim  good solution if you want to filter on these two sources but using 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:

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

``````

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Memorable Member

I use your expression , every row return 11 ?

Where i go wrong ? Can you pls share with me.

Paul

Announcements