Forum Discussion
Matrix Totals & Visual issue
Hi Msampedro ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. Fixed the measure for now.
I am including .pbix file for your better understanding, please have a look into it:
Thank you.
The issue is comming from your mesasure:
Theorical Sales"
Theorical Sales = [Unique Qty]*SELECTEDVALUE('2. Renault Price List'[Price DAP €/kg])This measure needs one and only one value return from SelectedValue, if many values are returned, the measure will be blank
If you add a table with this field and select a value, you will have value in your matrix:
For the issue with Consumption actual vs Theorical, you used a conditional formatting which is hidding your value
If I removed it, I get some values
Do not hesistate to ask if you need more support to fix these issues
Thanks Cookistador
Regarding the measure "Actual consumption" - Do you know how I can adapt the formula to see the totals?
Also - Do you know how to correctly visualize the below 3 measures?
Many thanks,
Miguel
hI Msampedro
Use IN...VALUES instead of = SELECTEDVALUE
Unique Qty = VAR _Raw = VALUES ('Material Mapping'[GMC]) RETURN IF( ISINSCOPE('Material Mapping'[Billing GMC]) || ISINSCOPE('Material Mapping'[Billing GMC description]), BLANK(), -- Hide duplicates for each Billing GMC CALCULATE( SUM('Qty ACT QP1'[Quantity_in_Entry_Unit]), 'Qty ACT QP1'[GMC] IN _Raw ) )There’s already a relationship between your fact and dimension tables, so why use a measure that just filters based on slicer selections? The relationship should handle that filtering automatically when you pick something in the slicer.
