Forum Discussion

masitbaha's avatar
masitbaha
Regular Visitor
8 years ago
Solved

Getting % by group (stacked column chart) - with filtered item

Hi guys.    Need help. My data is like this;   Week           Product       Qty     Pass/Fail    EXPECTED_RESULT 1                      A              2         Fail            2/(2+3+4+6) = 13....
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    masitbaha

     

    As a MEASURE try this one

     

    Measure =
IF (
    HASONEVALUE ( TableName[Qty] ),
    VALUES ( TableName[Qty] )
        / CALCULATE (
            SUM ( TableName[Qty] ),
            FILTER ( ALL ( TableName ), TableName[Week] = VALUES ( TableName[Week] ) )
        )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

masitbaha

 

As a MEASURE try this one

 

Measure =
IF (
    HASONEVALUE ( TableName[Qty] ),
    VALUES ( TableName[Qty] )
        / CALCULATE (
            SUM ( TableName[Qty] ),
            FILTER ( ALL ( TableName ), TableName[Week] = VALUES ( TableName[Week] ) )
        )
)
masitbaha's avatar
masitbaha
Regular Visitor
8 years ago

this works nicely. i also found another way to get the same result using measure;

 

Percentage = sum(Table[Qty])/CALCULATE(sum(Table[Qty]),GROUPBY(Table,Table[Week]),all(Table))