Forum Discussion

Fahim78666's avatar
Fahim78666
Regular Visitor
1 year ago

Power bi

I need to know how to calculate the sales category on general customers For example how many sales completed from the range of $1 to 50 and $50 to $100 Please help me to do this using power bi   ...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Fahim78666 

Based on your needs, I have created the following table.

 

 

First of all, you need to categorize the sales of different customers

category = IF(SELECTEDVALUE('Table'[sales])>=1 && SELECTEDVALUE('Table'[sales])<50,
"$1 to 50" ,
IF(SELECTEDVALUE('Table'[sales])>=50 && SELECTEDVALUE('Table'[sales])<=100,
"$50 to $100",
BLANK()))

 

Then count the different sales categories.

count = 
VAR _category = [category]
VAR _count = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[category]=_category))

RETURN _count

 

 

 

 

 

 

 

 

 

 

Best Regards,

Jayleny

 

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