Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I think its misconfigured this alert, could someone help me solve this please?
In my PBI report I've create a measure which is just a percentage, then I show that measure in a Card (its the only thing i need to show a single number), after that i've set an alert in Reflex, but instead of getting the data as a property it seems like its asigned as a column Key
So I dont want that many IDs each time we refresh the dataset (1H), we have 25 wich is wrong
In that case i only want one ID 'Average Measure' and that numbers should be the property
Any suggestions to solve this?
Solved! Go to Solution.
Hi @LeoG ,
I did some testing and this is my test data:
I create some measures and put them both into the table visual and the card visual:
If I create the alert from card visual, it only has one ID:
But if I create the alert from table visual, it has several IDs:
So please try to create alerts from Card visual directly.
If there are still questions, please continue to contact me.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks it works, why this happened?
@LeoG , just to add to the replies you've already had: if you create an alert on a table, then the alert will apply to each row in the table. For example, suppose you have the table below, showing sales per region. Suppose you set an alert on this table: "alert if sales become greater than $4m". Then you will get an alert if sales for any region become greater than $4m. I've shown below a simple sequence that would generate an an alert for the "West" region.
Yesterday: sales for all regions are less than $4m -- no alert generated
Region | Sales |
South | $1m |
North | $2m |
East | $3m |
West | $3.8m |
Today: sales for "West" region become greater than $4m -- Data Activator alerts you for the "West" region
Region | Sales |
South | $1m |
North | $2m |
East | $3m |
West | $4.1m |
Hi @LeoG ,
My understanding is that because when you put a measure in a card visual, the measure does not apply filtering because the card visual contains only one value and no other dimensions. But when you put the measure in table visual or other visual objects with multiple dimensions (e.g. visual objects with x-axis), the measure automatically applies filtering.
Best Regards,
Dino Tao
Hi @LeoG ,
I did some testing and this is my test data:
I create some measures and put them both into the table visual and the card visual:
If I create the alert from card visual, it only has one ID:
But if I create the alert from table visual, it has several IDs:
So please try to create alerts from Card visual directly.
If there are still questions, please continue to contact me.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.