Forum Discussion
Create Dynamic Text to Alert User Based on Measure
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!
Hi Anonymous ,
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.