Forum Discussion

DimaMD's avatar
DimaMD
Solution Sage
4 years ago
Solved

Count unique rows plan

Hello community! I have a task, need your help to solve it.    We have two tables, one of them - date and month; second - customer and product ID's, number of line. Based on one month (february) ...
@dax @help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the measure.

     

     

    fix measure =
VAR conditiontable =
    FILTER ( Plan, Plan[Contract] IN { "Own production", "Trading" } )
VAR nonconditiontable =
    SUMMARIZE ( EXCEPT ( Plan, conditiontable ), Plan[Contract] )
RETURN
    COUNTROWS ( conditiontable ) + COUNTROWS ( nonconditiontable )
PiEye's avatar
PiEye
Resolver II
4 years ago

In this example, you can use an IF() statement to check whether the column has the value you wish, and then returns a different count depending on it.

 

"IN()" checks the value against a list of values.

 

EG

IF(SELECTEDVALUE(Table[Contract]) IN {"Production","Trading"}
,
  DISTINCTCOUNT(Table[product ID]),
  count(Table[product ID]))
 
Does this work for you?
 
Pi