Forum Discussion

woolf's avatar
woolf
Frequent Visitor
2 years ago

How to GroupyBy to keep filtered values

Hi, I'm fighting with GroupBy/Summarize. I've a imported table with Category, Region, Market, ProductId. I want to filter the table in the dashboard to see the available products in the different sho...
Need Help
Tutorial Requests
woolf's avatar
woolf
Frequent Visitor
2 years ago

Thanx for the quick answer! For showing the numbers it's works perfect. But how can I implement an additional criteria. "Based on the current active filters show me stocks smaller 1 (Order now) and greater 2 (No further action)."

 

I've two measures now. Count_1 = COUNTA( 'Table'[ProductId] ) and a second one Count_2 = IF([Count_1]=1,"Order now","No further action")

 

Why I need it based on the filters? If I've 4 pieces in Spain, I can check the different shops and I've to identify is there a Shop with more then 2 pieces and I can shift it from to another. 

 

That was the reason why I tried it with new table but the filtered values were not available.

StockCompare=ADDCOLUMNS(GROUPBY('ImportedTable','ImportedTable'[ProductID],"Cnt.",COUNTAX(CURRENTGROUP(),'ImportedTable'[ProductID])),"Stock",IF([Cnt.]=1,"Order now","No further action"))

 

ProductIdCount_1Count_2
15744982No further action
15745361Order now
15746411Order now
15746592No further action
15746691Order now
15756121Order now
15756792No further action
15756931Order now
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi woolf ,

     

    You can do this by simply using an if statement:

    Measure 2 = IF([Measure]=1,"order now","No further action")

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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