Forum Discussion

YudhaHartono's avatar
YudhaHartono
Regular Visitor
1 year ago
Solved

Need help for Dynamic Column Total Percentage

Hi Everyone   I'm currently trying to replicate the Column Total Percentage feature on Power BI using Measure. The reason I need a measure for that is because I want to utilize the Parameter to be...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi YudhaHartono,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community. Also, thanks to speedramps  for the prompt and helpful response, and for sharing valuable suggestions about the community.

     

    Could you please share some sample data that we can use to better understand and assist with your issue?

     

    Best regards,
    Prasanna Kumar

speedramps's avatar
speedramps
Super User
1 year ago

Hello again YudhaHartono 

Your Product table has used the wrong datatype for SKUs.

 

 

Your Product table has duplicate rows for SKUs.
A Product Dimension should have a unqiue product id for each product, collection and style combination

You shoudl then use this product id in the fact table relationshios
 

Fact tables need a  product id to relate back to the product table
You Fact Table has SKU and Collection. Neither of these are unqiue

I see you are a new member.

I want to heklp you but posting your buggy dax and all your data with a vague explanation and expecting us to do your job for you, is not the purpose of this forum. ðŸ˜€ðŸ˜€

 

Please follow the instructions we provided to write a clear question.

Ask you manager, a collegaue or teacher (if you are student) to help you write the question clearly. Thank you.

 

Simplify your problem, buy asking one question at a time with the minimal data.

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming


* Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy). 

* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.