If >2 Selections, do not display the graph, else display the graph

[Anonymous]

Hey,

I'm trying to make a measure that will not display a sum on a graph if certain criteria are met. However, instead of breaking it goes ahead and displays the sum regardless of whether or not the if statement conditions are met. How can I make a measure that will not display aggregated counts if certain criteria are met?

Ex - 

Input: 24, 52, 37

Measure: If(Count(Input)>2, "Please maintain 1-2 inputs", Sum(Input)

Desired Output: "Please maintain 1-2 inputs"

Actual Output: Sum(Input)

[v-shex-msft · Accepted solution]

HI @Anonymous,

Greg's suggestion seems well, I share the sample formula here.

Measure =
IF (
    COUNTROWS ( ALLSELECTED ( Table[Input] ) ) > 2,
    "Please maintain 1-2 inputs",
    SUMX ( ALLSELECTED ( Table[Input] ), [Input] )
)

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you both!!

[Greg_Deckler]

Might have better luck with COUNTROWS instead of COUNT if it is a table. 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490