Need Urgent help with building . Beginner in Power BI.

[Jiahui2805]

Hi, i need to do up a report based on my data below.

Hope can get some help as i am still very new to power bi.

Appreciate all the help i can get.

Thanks!

[Anonymous · Accepted solution]

Hi @Jiahui2805 

You can create several measures as follow.

Apr = 
VAR _a = CALCULATE(SUM(DATA[Value]), FILTER(ALLEXCEPT(DATA, DATA[Shape]), EXACT(DATA[Months], "Apr") && EXACT(DATA[Categoy], "Applicable for Discount")))
VAR _d = CALCULATE(SUM(DATA[Value]), FILTER(ALLEXCEPT(DATA, DATA[Shape]), EXACT(DATA[Months], "Apr") && EXACT(DATA[Categoy], "Discount")))
RETURN
DIVIDE(_d, _a)

May = 
VAR _a = CALCULATE(SUM(DATA[Value]), FILTER(ALLEXCEPT(DATA, DATA[Shape]), EXACT(DATA[Months], "May") && EXACT(DATA[Categoy], "Applicable for Discount")))
VAR _d = CALCULATE(SUM(DATA[Value]), FILTER(ALLEXCEPT(DATA, DATA[Shape]), EXACT(DATA[Months], "May") && EXACT(DATA[Categoy], "Discount")))
RETURN
DIVIDE(_d, _a)

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qqqqqwwwweeerrr]

Hi @Jiahui2805 

I have created a random data set in excel which looks like this 

and by creating these measure you can get what you what.

Applicable for Discount = CALCULATE(SUM(Sheet1[Value]),FILTER(Sheet1,Sheet1[Catregory] = "Applicable for discount"))

Discount = CALCULATE(SUM(Sheet1[Value]),FILTER(Sheet1,Sheet1[Catregory] = "Discount"))

percentage = DIVIDE([Discount],[Applicable for Discount])

and by using these above measure results looks like this

Hope this solves your problem if not please share more details 

 Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards