Forum Discussion

Msampedro's avatar
Msampedro
Helper I
8 months ago
Solved

Matrix Totals & Visual issue

Hi all, Dealing with the following 2 issues (Attached a PBI example file).   The Visual (Sales Actuals vs Theorical) on page "Insights option". I am not able to properly visualize fields/measures...
Need Help
  • Anonymous's avatar
    Anonymous
    8 months ago

    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.

Msampedro's avatar
Msampedro
Helper I
8 months ago

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

danextian's avatar
danextian
Super User
8 months ago

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.

 

  • Msampedro's avatar
    Msampedro
    Helper I
    8 months ago

    Thanks danextian 

     

    I am using a measure to avoid the below (duplicates at Billing GMC description level). 

     

    I have tried with VALUES instead of SELECTEDVALUES and I have received the below message. Let me know if any other idea! Many thanks

     

    • danextian's avatar
      danextian
      Super User
      8 months ago

      did yo use IN _Raw or = _Raw?