Forum Discussion

liz_rowden's avatar
liz_rowden
Regular Visitor
10 months ago
Solved

Matrix Visual & Product Line Attributes

I have sales data that looks something like below: Item # Product Line on Item Sale Amount Industrial Sale? Month A100 BAKERY $100 N JAN A200 INDUSTRIAL $100 Y JAN A300 DELI...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    10 months ago

    Hi,

    These measures work

    S = SUM(Data[Sale Amount])
    Measure = if(HASONEVALUE(Data[Product Line on Item]),if(MAX(Data[Product Line on Item])="Industrial",CALCULATE([S],Data[Industrial Sale?]="Y",all(Data[Product Line on Item])),[S]),[S])

    Hope this helps.

  • v-ssriganesh's avatar
    v-ssriganesh
    10 months ago

    Hi liz_rowden,
    I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it. I am also including .pbix file for your better understanding, please have a look into it:

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Fabric Community Forum.


    Best regards,
    Ganesh Singamshetty.

v-ssriganesh's avatar
v-ssriganesh
Community Support
10 months ago

 

Hello liz_rowden,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.