Forum Discussion

srkase's avatar
srkase
Helper IV
6 years ago
Solved

MULTIPLE FILTRATION

I have the data like this...   YEAR SHORTNAME DEALER TYPE PRODUCT APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR TOT CATEGORY 20182019 AB A STD PROD 10 0 0 0 0 0 ...
Need Help
  • srkase's avatar
    srkase
    6 years ago
    v-chuncz-msft wrote:

    srkase 

     

    You may use the following measure.

    Measure =
COUNTROWS (
    FILTER ( VALUES ( cab[DEALER] ), CALCULATE ( SUM ( cab[QTY] ) <= 1000 ) )
)

    it gives only true or false...

     

    I applied this measure ... and works fine..

     

    qty500 = CALCULATE (
    DISTINCTCOUNT('BREAKUP CABLES'[DEALER] ),
    FILTER ( ALL ( 'BREAKUP CABLES'[DEALER] ), 'BREAKUP CABLES'[sumqty]<=499))

     

srkase's avatar
srkase
Helper IV
6 years ago

In a month a dealer might have taken items in many invoices... The sum we should check and get the total and then the measures should be applied..

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

srkase 

 

You may use the following measure.

Measure =
COUNTROWS (
    FILTER ( VALUES ( cab[DEALER] ), CALCULATE ( SUM ( cab[QTY] ) <= 1000 ) )
)
  • srkase's avatar
    srkase
    Helper IV
    6 years ago
    v-chuncz-msft wrote:

    srkase 

     

    You may use the following measure.

    Measure =
COUNTROWS (
    FILTER ( VALUES ( cab[DEALER] ), CALCULATE ( SUM ( cab[QTY] ) <= 1000 ) )
)

    it gives only true or false...

     

    I applied this measure ... and works fine..

     

    qty500 = CALCULATE (
    DISTINCTCOUNT('BREAKUP CABLES'[DEALER] ),
    FILTER ( ALL ( 'BREAKUP CABLES'[DEALER] ), 'BREAKUP CABLES'[sumqty]<=499))