Forum Discussion
Measure for KPI
I have a requirement where i need to show the value of Target when all SU is selected and then filter the target value by SU.
that is for january if all SU is selected then the target should be 94.40% and when AAO is selected it should show 94.30 and so on.
Please find the attached table,
A help is needed ,Do i need to create a measure or column?
5 Replies
Anonymous not sure what you mean when all SU selected then filter the target by SU, can you elaborate?
Anonymous ,
Not sure, to you need Avg Target Try
averagex(allselected(Table),Sum(Table[Target]))
Hello Amit i created another post and explained it briefly with some more screenshot.
https://community.powerbi.com/t5/Desktop/KPI-calculated-measure/m-p/1060508#M495480Hi Anonymous ,
Maybe you could try like this:
Measure = VAR SBU = ALLSELECTED ( 'Table 2'[SBU] ) VAR CountSelectedValue = COUNTROWS ( SBU ) VAR Target = CALCULATE ( SUM ( 'Table'[Target] ), FILTER ( 'Table', 'Table'[SBU] IN SBU ) ) VAR Default = CALCULATE ( SUM ( 'Table'[Target] ), 'Table'[SBU] = BLANK () ) RETURN IF ( CountSelectedValue = 12, Default, Target )You could reference the blog of similar topic.
Slicer with AND condition in Power BI
Please download my sample to learn more details.
