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 )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
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 )
DimaMD's avatar
DimaMD
Solution Sage
4 years ago

Ні, Jihwan_Kim 
Thanks for the help, your measure worked

Greetings from Ukraine.