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

     

AnthonyTilley's avatar
AnthonyTilley
Icon for Solution Sage rankSolution Sage
7 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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