Forum Discussion
DAX Measure for Active Contracts based on a value
Hello, and thank you! I've already done that, with the measure that I have. And I have the Active Contracts in a line diagram, it's working.
When I try to add Grid Owner Name to legend, it's not working. Somehow the line flattens out.
And anyway I would need one line for total, than one line for each of those.
So I thought if I could create one measure for total active contracts, as I already have;
then one measure that used the same calculation, but only based on rows with the correct Grid owner name? Is that possible?
Helper IUnfortunetaly, line chart can have only one measure.
However, there is a hack to do that:
1 . In Power Query window: copy you query
2 . Replace each contract type with the word "All"
3 . Append quiries together.
By doing those steps you will have doublicate data in your table with contract type called All
Hope that's helps you.
Best wishes.
----------------------------------------------
Did I answer your question? Mark my post as a solution!