Forum Discussion
Dax Query
Hi Team, I am new to Bi and stucked into one of the issue in which i want to show the minimum value in matrix. For example - suppose there are 3 trainings (A,B,C) and in india 3 people completed ...
Step 1: I use ’DATA’ table below.
Step 2: I make a measure.
Min Number = CALCULATE(MIN('DATA'[Number]),ALLEXCEPT('DATA',DATA[Country]))
Step 3: Imake a matrix.
'DATA' table:
Country Trainings Number
India A 3
India B 2
India C 1
USA A 6
USA B 5
USA C 4
UK A 8
UK B 7
UK C 3