Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

LOOKUPVALUE not working

Hi!
 
The idea of this file is to measure the number of Mistakes an employee makes per Game Round. 
 
So I have two KPI's, No. of Rounds, which comes from the DWH, and an excel file which is centralized and has the Mistakes in it.
 
Note: only December mistakes have been loaded as a test. So for all other months, we should have Game Rounds but null mistakes.
Bridge tables are there to remove Many to Many relationships.
 
So I have 2 problems with this file. 
 
1) The dates don't seem to be working properly - which looks like a relationship issue but ive tried all 3 date measures and non are working as they should
 
2) I would either like Mistake No. (#) and No. of Rounds (#) to be in the same table OR for a lookup to work so that I can divide one by the other to get the end result i need.
 
Final result should be four columns in one table (filter for date), Dealer Name, No. of Rounds, No. of Mistakes and Average Mistake per Dealer
 
I've attached the file along with some screenshots of my issues. This is of course dummy data for the purposes of sharing.
 
I can send the pbi file in private message if anyone is kind enough to lend a hand please.
 
Huge thank you in advance!!
 
 
 
 
 
 
Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , As the dealer name is coming from a fact and No. of Mistakes coming from another fact, I doubt it can give the correct number always.

    do you have the dealer name or number in another fact?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak Thanks for replying first of all. 

     

    These are my only 2 fact tables with dealer name in it. One gives me one kpi, the other gives me the other kpi (as its a manual input). Somehow i ned to combine them, are you thinking its not possbile?

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , You can display dealer name with No. of Mistakes, with help from a middle dimension, but that will not guarantee the correctness of data

       


      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Share the download link of a small sample PBI file and show the expected result on that file.