Create Dynamic Text to Alert User Based on Measure

[TheQ]

Hi everyone,

I'm making a report to analyze some data. I want to implement an alert to check that the data uploaded is done correctly. Let's say I have data that looks like this:

Group	Expected	Actual	Difference (DAX)
A	1	1	0
A	2	1	1
A	3	3	0
B	4	4	0
B	3	3	0
B	2	2	0
C	3	3	0
C	3	2	1
C	5	5	0

My end goal is to have a text box or card of some sort that will say something like:
"Please check the data upload for Groups A & C."

or "Data uploaded correctly" if all Groups produce 0s for Difference.

What's a good way to accomplish this? Thanks!

[v-rzhou-msft · Accepted solution]

Hi @TheQ ,

Please try this code to create a measure.

Measure = 
VAR _Find_Group = SUMMARIZE(FILTER('Table','Table'[Difference] = 1),'Table'[Group])
VAR _RESULT1 = "Please check the data upload for Groups" &" "&CONCATENATEX(_Find_Group,[Group]," & ") &"."
VAR _RESULT2 = "Data uploaded correctly"
RETURN
IF(SUM('Table'[Difference])>0,_RESULT1,_RESULT2)

My Sample:

Result is as below.

Best Regards,
Rico Zhou

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

[TheQ]

That works! Thanks for the help, Rico!