Forum Discussion

Aikeno's avatar
Aikeno
Icon for Helper I rankHelper I
2 years ago

Measure based on several conditions

Hello everyone,   I would like to have a measure that would give me the result in the column "Test done" in blue table in my report. Yellow and orange are data table and they are linked by the Pro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Aikeno ,

Could you please provide some fake data in your tables (exclude sensitive data) with Text format and your expected result with special examples and screenshots? Later I will check why the formula is not working in your side and give you a suitable solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Aikeno's avatar
Aikeno
Icon for Helper I rankHelper I
2 years ago

Hello,

 

Here is the simplified data :

https://www.mediafire.com/file/skwecp8ym4f6zuz/Power+BI+with+fake+data.pbix/file

 

 

For the blue table on the left, I would like to replace my measure to display "Yes" or "No" instead of the activites count and also be able to see all the project not only the one who have a Vibration review closed.

 

For the blue table on the right it seems to works on this simplified data but not in my real one can't explain why. 

  • Aikeno's avatar
    Aikeno
    Icon for Helper I rankHelper I
    2 years ago

     

     

    My problem here seems to be link to my column required date and completed date because if I delete CompletedDate and for the RequiredDate I choose the most recent one instead of dont resume it works well.

     

    No clue how I can solve this problem