Forum Discussion
Solved
Divide two columns only with values on dimension level en create KPI without dimension
Hallo, I want to divide two values. In a tabel I can use filter to exclude the blank values but if I take out the dimension rows then the filter doesn't work any more. Here my data: I want to divid...
Hi Jana2102
It is always important that when providing a sample data to describe where the numbers are from. Also, in the future please post a sample data that we can copy paste to Excel.
I modifed my formula a bit to point them to different tables but I am seeing 75%.
Please see the attached sample pbix.
