Forum Discussion

JureGa's avatar
JureGa
New Member
5 years ago
Solved

Grouping Data with Ponders

Hi Power BI Community,   I would like to know if it is possible to create groups in Power BI with ponders for some values, for example I have database of 3 different products (which are in fact the...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi JureGa ,

     

    We can use the split function to meet your requirement.

     

    1. In Editor Query, split the Product column by “x”.

     

     

    2. Then we need to group the product.1 and product.2.

     

     

    3. At last, we can create a measure to get the result.

     

    Measure 2 = 
SUMX('New table',CALCULATE(SUM('New table'[Product.1]))*CALCULATE(SUM('New table'[Sum_quantity])))

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi JureGa ,

 

We can create a measure to meet your requirement.

 

Measure = 
SUMX(
    SUMMARIZE(
        'Table','Table'[Product],"column1",
        SWITCH(
            TRUE(),
            CONTAINSSTRING(MAX('Table'[Product]),"50x")=TRUE(),SUM('Table'[Quantity])*50,
            CONTAINSSTRING(MAX('Table'[Product]),"5x")=TRUE(),SUM('Table'[Quantity])*5,
            CONTAINSSTRING(MAX('Table'[Product]),"1x")=TRUE(),SUM('Table'[Quantity]))),
    [column1])

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

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

 

BTW, pbix as attached.