Forum Discussion

gauravsukhadia's avatar
gauravsukhadia
Frequent Visitor
4 years ago

Trip Distinction between product groups

Hi Team, I have one question, I have huge dataset which contains thousands rows product level details ( fact table ) and each row has Run Sheet ID ( trip on which that line was shipped ) now I want t...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

gauravsukhadia , Try measures like

 

Product's Single trip


Countx(addcolumns(summarize(Table, Table[trip ID]), "_1",distinctCOUNT(Table[Product ID]), "_2",calculate(distinctCOUNT(Table[Product ID]), all(Table))),If([_1] =[2], [Trip ID], blank()))

 

Trip with other

 


Countx(addcolumns(summarize(Table, Table[trip ID]), "_1",distinctCOUNT(Table[Product ID]), "_2",calculate(distinctCOUNT(Table[Product ID]), all(Table))),If([_1] <[2], [Trip ID], blank()))