Forum Discussion

LyonsBI_BRL's avatar
LyonsBI_BRL
Icon for Helper III rankHelper III
5 years ago

Grouping Values together in IF statement

I'm completely stuck on an IF statement that I need to create here for the following scenario The scenariio is I need to create a calculated column (that or if a measure would work better that'd wor...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  LyonsBI_BRL  ,

Here are the steps you can follow：

1. Create measure.

MegaDeals_New =
Var _Company=MAX(Query1[Organizationt])
Var _TotalUnits=SUMX(FILTER(ALL(Query1),Query1[Organization]=_Company),Query1[[Units])
Return
SWITCH(True(),
_TotalUnits > 1000, "Mega Deal",
_TotalUnits <500, "Under 500",
"Not Mega")
card =
COUNTAX(FILTER('Query1','Query1'[MegaDeals_New]="Mega Deal"),'Query1'[Organization])

2. Place [Organization] in the slicer, and place [card] in the card image

3. The result looks like this

 

Best Regards,

Liu Yang

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