Customers Grouped by Count of Their Orders Static Segmentation in Power BI
One of the interesting calculation challenges in BI systems is a segmentation or grouping on a numeric value, based on an occurrence of another value. As an example; You might want to know How many customers ordered once, twice, three times or more. The challenge is that the data in the transactional table is not aggregated, and this type of calculation needs two aggregations. There are two ways of calculating such a thing in Power BI; statically or dynamically. In this video, I'll explain the static method for this calculation.
Download the power bi file from my blog post here:
https://radacad.com/customers-grouped...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: https://learn.radacad.com
Become an academy member: https://learn.radacad.com/product-cat...
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / 6393399
-- https://radacad.com
********