Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX problem when adding a measure in matrix it displays multiple rows

I have a matrix where with some values (name of a program and professors) in Rows and some measures in Values. The problem is that when I try to add a new measure based on two other measures it displ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    I have the same problem using unique measure.

     

    At the end I've solved it by using the measure unique changing the "0" result by "Blank()"

    Unique = 
IF(
    [Accepted Class Time] >= 15 && [Accepted Standard (75 min)] = 0;
    1;BLANK()
)

     

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

Why not drag the Unique to the visual?It seems there's no need to use Unique Session measure.

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I have the same problem using unique measure.

     

    At the end I've solved it by using the measure unique changing the "0" result by "Blank()"

    Unique = 
IF(
    [Accepted Class Time] >= 15 && [Accepted Standard (75 min)] = 0;
    1;BLANK()
)