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.

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

I am not very clear about the problem you describe. Please give me some screenshots.

 

Best Regards,

Icey

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Icey,

 

Thank you so much for your help and others as well.

Its really amazing and this forum is very helpful.

 

I was confusing before with your solution but I got clarity now because I'm looking for sum of defected but you have done count of measures. Sorry, its my mistake I should have told you before. I've created another sum of measures then I got the answer.

 

I got one more question please...

Can we create same measures in dCalendar table instead of doing another table like as you done?

 

Kind regards,

pv