Forum Discussion
filtering matrix by columns
Anonymous
Try placing this measure in a card visual:
BoughtInEneroAndFebrero = VAR _BoughtInEnero = CALCULATETABLE ( DISTINCT ( Table1[IDCLIENTE] ), Table1[MES] = "Enero" ) VAR _BoughtInFebrero = CALCULATETABLE ( DISTINCT ( Table1[IDCLIENTE] ), Table1[MES] = "Febrero" ) RETURN COUNTROWS ( INTERSECT ( _BoughtInEnero, _BoughtInFebrero ) )I'm assuming that an IDCLIENTE will only come up in the table for a specific month if there have been sales (i.e. it cannot be the case that you have a blank in IMPORTE
Hi AlB, In fact I have already the data unpivotted like this. What I want is to know the number of clients who have bought in both months. Thanks!
Community ChampionAnonymous
Try placing this measure in a card visual:
BoughtInEneroAndFebrero =
VAR _BoughtInEnero =
CALCULATETABLE ( DISTINCT ( Table1[IDCLIENTE] ), Table1[MES] = "Enero" )
VAR _BoughtInFebrero =
CALCULATETABLE ( DISTINCT ( Table1[IDCLIENTE] ), Table1[MES] = "Febrero" )
RETURN
COUNTROWS ( INTERSECT ( _BoughtInEnero, _BoughtInFebrero ) )
I'm assuming that an IDCLIENTE will only come up in the table for a specific month if there have been sales (i.e. it cannot be the case that you have a blank in IMPORTE
AlB Thanks! It works. Finally do you know how can I add a month slicer in the same scenario to make it dinamically? Because that measure has "Enero" and "Febrero" hardcoded. Would it be possible to do it with a slicer?
Thank you! You helped me a lot