Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Representing a single row in a visual

Hi everyone.   I have a large data set which has many rows with an ID number and a value for year. I want to create a line chart which shows the value for each year. This part is easy but I also w...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks !

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , one way is to have common facility dimesnion

 

second is use treatas pass value to another table measure

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

 

or measure like

calculate(countrows(table1), filter(Table1, Table1[facility] in values(Table2[Facility]) ))

 

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda