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

[Anonymous]

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 displays multiple rows that I don't want. This is my case:

Then if I add the new measure that is based on Accepted Class Time and Accepted Standard (75 min) it displays all professors even if they didn't make that program.

The measures that I am using are:

Accepted Class Time = 
SUMX(SESIONCURSO; SESIONCURSO[MINUTOS] * SESIONCURSO[CONFIRMADA] * SESIONCURSO[Role Accepted]) 

Accepted Standard (75 min) = 
ROUND(
    DIVIDE([Accepted Class Time]; 75);
    0
    )

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

Unique Session = 
CALCULATE(
    [Unique];
    ALLEXCEPT(I4_PS_PROGRAM;I4_PS_PROGRAM[NOMBRE]);
    ALLEXCEPT(PROFESOR;PROFESOR[Apellido_Nombre])
)

Programs and professors are in separte tables. I want to add Unique Session measure but only to the rows visible in the first table. 

Thanks!

[AkhilAshok]

Can you try Unique measure this way:

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

[AnthonyTilley]

Would you beable to refrence one of the other measures that is showing blank and if they are blank return Blank instead this should remove all the extra lines from your visual where the you do not want a result to be shown 

For example 

Unique Session =

IF(PlannedTimeSlot = Blank(),BLank(),

CALCULATE(

[Unique];

ALLEXCEPT(I4_PS_PROGRAM;I4_PS_PROGRAM[NOMBRE]);

ALLEXCEPT(PROFESOR;PROFESOR[Apellido_Nombre])

))

[Anonymous]

@AnthonyTilley
@mwegener 
Hi

I am trying to use a DAXmeasure in Matrix report Power BI, but its giving me wrong column total but correct row total. Can you please recommend me is it possible to fix this or it has to be only row total. 

I have provided the screenshort of my measure, report and expected output. 

Report

Report
I am getting above output as my measure is behaving as below:

BEHAVIOR ( WRONG)
------------------------------------------------------------------------------------------------------------------------
MY ACTUAL MEASURE

Measure

----------------------------------------------------------------------------------------------------------------------------------------

Expected Output

Expected Output

[v-cherch-msft]

Hi @Anonymous 

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

Regards,

[Anonymous · Accepted solution]

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()
)