Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Alberto95
Frequent Visitor

trouble with measures in the matrix table

hi, i've a trouble with a pwbi report. i need yo have a % mesure on each rows in the matrix below. the problem is when i calculate the % mesure in the subrows.

not all the rows are wrong but only the sub-rows, the column in error is the column Cons%

 

 

Alberto95_0-1679046068165.png

 

for this report i have used 2 different mesures:

 

Ricavi = CALCULATE(sum(BILANCIO[TOTALI]),Riclassifica[cGruppoDir]= 10)
Cons% = ABS(BILANCIO[Cons])/MISURE[Ricavi]
 
if someone can help me.
i can also shared the pbix file.
thanks to all
 
2 REPLIES 2
marcl1
Helper II
Helper II

Hi,

you shouldn't use the / to make division but use the function divide 🙂
try
Cons% = DIVIDE(ABS(BILANCIO[Cons]),MISURE[Ricavi])

it should solve your case...

isn't ok.

 

With DIVIDE function the result is this. i don't see the text "infinito" but however i don't see the % value.

 

Alberto95_0-1679050346386.png

 

i think the problem consist in the relation with the tables. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.