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

Hi liz_rowden,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to johnt75 for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.