Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Does anyone know why I get an incorrect 43%? Oh, data types are:
IsCompliant: Whole Number
Total: Whole Number
Measure2: Percentage of precision 2
2_NumDenom : Text
Thanks!
Solved! Go to Solution.
@Anonymous change the topN filter and manually select the filter value.
Great idea! However, they are both filtered only by the date.
I put those two items in a table and got what I would expect. It appears to be an issue with the card object that shows the 43%.
I went to change the Timeseries_DT filter to basic filtering (which defaulted to the earliest date). I changed to the last date, and it didn't change. That's strange. I poked around and the issue is that most tables have a "Timeseries_DT" field that is the date of every row. Somehow, the % card was pulling from another table's "Timeseries_DT" column. I made it the correct one, and it works!
Thank you for helping me back up and work this issue out!