Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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() )
Can you try Unique measure this way:
Unique = IF ( NOT ( ISEMPTY ( SESIONCURSO ) ); IF ( [Accepted Class Time] >= 15 && [Accepted Standard (75 min)] = 0; 1; 0 ) )
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
Proud to be a Super User!
@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
I am getting above output as my measure is behaving as below:
------------------------------------------------------------------------------------------------------------------------
MY ACTUAL MEASURE
----------------------------------------------------------------------------------------------------------------------------------------
Expected Output
Hi @Anonymous
Why not drag the Unique to the visual?It seems there's no need to use Unique Session measure.
Regards,
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() )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |