Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |