Forum Discussion

ergocorp's avatar
ergocorp
Helper II
4 years ago
Solved

Measure as Slicer

This has come up quite a lot, but in my case I have a relatively huge table (13 million rows, 44 columns, 20 measures), so it's a bit of a slog to try and unpack for my scenario!   Boiling it down ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ergocorp , if you want to use filter on measure then use the filter. Also, this need to be done with some group by

     

    Example

    sumx(filter(values(invoice[invoice_id]) , [measure]>1) ,[Measure2] )

     

    or

     

    Calculate( [Measure2],

    filter(values(invoice[invoice_id]) , [measure]>1)  )

  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Your [Example issue] needs a FILTER expression. Something along the lines of:

    Example issue =
CALCULATE (
    DISTINCTCOUNT ( '01-Payments'[Supplier name] ),
    FILTER ( '01-Payments', [YesProportion] < 1 )
)
amitchandak's avatar
amitchandak
Super User
4 years ago

ergocorp , if you want to use filter on measure then use the filter. Also, this need to be done with some group by

 

Example

sumx(filter(values(invoice[invoice_id]) , [measure]>1) ,[Measure2] )

 

or

 

Calculate( [Measure2],

filter(values(invoice[invoice_id]) , [measure]>1)  )