Forum Discussion
meena16_vibrant
3 years agoFrequent Visitor
DAX Help
In a matrix, I need to show below measures for each column. coln 1 measure 2 coln 2 Average(coln4) coln 3 Max(Coln4) I tried using below measure but I get error. Please help...
meena16_vibrant
3 years agoFrequent Visitor
AllisonKennedy
3 years agoCommunity Champion
meena16_vibrant Thanks - can you make your dummy data a bit more meaningful? I can't see why you have two rows with almost the same data and why that same data needs to be the trigger for a different measure. Can you simply do three measures:
AAA = [measure1]
BBBB = AVERAGE(table[coln4])
CCC = MAX(table[coln4])
And add those three measures to a matrix or table visual?