sum of a conditional result

[JorgePereira]

I have a "Status" measure that shows the result in the "Status" column. Now I need to add all the statuses "Postergado", "Mantido", "Economia", .... Can you help me how do I measure this?

I need this result below: a sum of the "Diferença 2020" values (difference 2020) by status.

[v-gizhi-msft]

Hi,

Please take following steps:

1)Create a slicer table as below by Enter Data:

2)Try this measure:

Measure = 
SWITCH (
    SELECTEDVALUE ( 'Slicer Table'[Category] ),
    "Antecipado", CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', [Status] = "Antecipado" ) ),
    "Postergado", CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', [Status] = "Postergado" ) ),
    "Mantido", CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', [Status] = "Mantido" ) ),
    "Maior", CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', [Status] = "Maior" ) ),
    "Economia", CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', [Status] = "Economia" ) )
)

3)The result shows:

See my attached pbix file.

Best Regards,

Giotto

[vivran22 · Accepted solution]

Hello @JorgePereira ,

As per my understanding, you can achieve this by creating a calculated table instead.

I have used the following steps:

Sample data:

Created following measures:

Total Orders = SUM(dtTable[Order Quantity])

Category = 
IF(
    [Total Orders] < 50,
    "Less than 50",
        IF([Total Orders] < 100,
        "b/w 50 & 100",
            IF([Total Orders] < 120,
                "b/w 100 & 120",
                "More than 120"
                )
        )
)

So, I can create visuals like this:

Then, created the calculated table:

Table = 
SUMMARIZE(
    dtTable,
    dtTable[Product Sub-Category],
    "Total ORders",[Total Orders],
    "Category",[Category]
)

Which can be used in the visual

Hope this helps.

Cheers!

Vivek


If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

(Hit the thumbs up button!)


If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


Visit my blog:

vivran.in/my-blog


Feel free to email me for any BI needs .


Connect on LinkedIn

Follow on Twitter