Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get data from table 2

Hi Guys, I hope you can help me. I'm new to the Power BI.   Table 1: Data from Mar 19 - till date Table 2: Data from Jan 19 - Feb 19 Table 3: Calendar table   I would like to get the data from...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

    Your column chart's x-axis and y-axis are both from Table 1, not Table 2. So, it will show blank when you choose "January" or "February". 

    Try this:

    1. Create measures. Please pay attention to your blank values in "Concatenate". Not blank, but "   ".

     

    Count of Defected data =
IF (
    MAX ( 'Data Collection'[Concatenate] ) = "   ",
    BLANK (),
    COUNT ( 'Data Collection'[Concatenate] )
)
    Count of defected =
IF (
    MAX ( 'dCollection(Jan-Feb)'[Concatenate] ) <> "   ",
    COUNT ( 'dCollection(Jan-Feb)'[Concatenate] )
)
    Defected all =
IF (
    ISBLANK ( MAX ( 'Concatenate'[Concatenate] ) ),
    BLANK (),
    [Count of defected] + [Count of Defected data]
)

     

    2. Create a table.

     

    Concatenate =
FILTER (
    VALUES ( 'Data Collection'[Concatenate] ),
    'Data Collection'[Concatenate] <> "   "
)

     

    3. Create a column chart.

     

    PBIX file attached.

     

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear vijaykolisetty,

Thank you so much for the reply. 

I've created measures. I hope you can understand after see the below print screen. I don't understand one more thing here, I created relationship with date column for three tables and if select column from one table then automatically show linked table (highlighted with tick mark for table in the left corner) but it doesn't show that.

 

I'm thinking my table relationship is wrong. Is that right?

 

Kind regards,

pv

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear Anonymous 

Thank you for the screenshot, in this case there are 2 possibilities 

1. To check the relationships or change the relationship type into bi-directional

2. Check the data type of the date or change the date column into date format and test the data.

 

Regards, 

Munna

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you Munna.  I'll check it.

     

    Kind regards,

    pv

    • Icey's avatar
      Icey
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Is this problem solved?

       

      If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


      If not, please let me know. And it would be great if you could share me your PBIX file without sensitive information.


      Best Regards
      Icey