Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a dataset simplified as below, and have a requirement to highlight repetitive amounts, per category per store.
How Can I do that with DAX please ?
Your help is very appreciated,
Thanks in advance
Solved! Go to Solution.
Repeated ? : =
VAR currentvaluetotal = [Value Total :]
VAR currentmonth =
MAX ( Months[Index] )
VAR newtable =
FILTER (
ALL ( Sales ),
Sales[Store] = MAX ( Stores[Store] )
&& Sales[Category] = MAX ( Categories[Category] )
&& [Value Total :] = currentvaluetotal
&& RELATED ( Months[Index] ) < currentmonth
)
RETURN
IF ( ISFILTERED ( Months[Index] ), IF ( COUNTROWS ( newtable ) >= 1, 1, 0 ) )
https://www.dropbox.com/s/4ybuju3e2nvpuko/mazer.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Repeated ? : =
VAR currentvaluetotal = [Value Total :]
VAR currentmonth =
MAX ( Months[Index] )
VAR newtable =
FILTER (
ALL ( Sales ),
Sales[Store] = MAX ( Stores[Store] )
&& Sales[Category] = MAX ( Categories[Category] )
&& [Value Total :] = currentvaluetotal
&& RELATED ( Months[Index] ) < currentmonth
)
RETURN
IF ( ISFILTERED ( Months[Index] ), IF ( COUNTROWS ( newtable ) >= 1, 1, 0 ) )
https://www.dropbox.com/s/4ybuju3e2nvpuko/mazer.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
82 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
108 | |
97 | |
86 | |
68 |