Forum Discussion

DylanSandry's avatar
DylanSandry
Frequent Visitor
2 years ago

Grouping matrix columns using custom measures

Hello,   I've been destroying myself trying to figure this out and I wonder if someone can help. I have the following table (Simplified to get to the root of my problem): Job Product Price ...
Need Help
Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

DylanSandry 

do the following : 
create a custom table :  ( No need for the Column "Column")

 

 
 
add column1 to the matrix. 
and now you just need to create 2 measures : 
TotalPrice
 and 
TotalCount
 
for each measure, use the switch statement :
switch(
true ( ),
   selectedvalue(table[column1]) =  "Today" , calculate( [total price] , date =  today () ,
selectedvalue(table[column1]) =  "This Month" , calculate( [total price] , year(sales[order date]) = year ( today() ,  month(sales[order date]) = month( today()) ,
.........., ,
 
 
 
let me know if this helps.